Welcome to the official Advantage Database Server feedback forum. Do you have an idea? We want to hear from you!
We always do our best to keep you informed of our future product plans, however keep in mind the product roadmap, features, enhancements, timelines and dates discussed in this forum are forward looking and are subject to change. Sybase iAnywhere retains sole discretion as to when, if ever, discussed enhancements will occur.
-
160 votes
Provide better way to detect and fix invalid table data.
We have some ideas on this, but would welcome any ideas or comments on what kind of functionality and utilties you would like to see.
-
154 votes
Ability to pack a table while in use
We have some preliminary brainstorming done and are excited about this feature and hope to add this to a future release. It is too late to include it as part of v10 in early 2010, however.
-
74 votes
ALTER TABLE on live dataset, no exclusive required
I'd like to be able to do an alter table on a live data set. No exclusive access for ALTER TABLE.
-
65 votes
Updateobject for TADSQuery
I would like to have a UpdateObject for a Query, so I can define the sql for update/Insert for a TADSQuery. this would avoid to make such things with Triggers
-
59 votes
Same Syntax for AOF and SQL-Where (LIKE, IN, ...)
It would be fine when the AOF (of a TADSTable) could have the same Syntax like the SQL-Where-Part of a TADSQuery.
-
47 votes
Avoid changed data immediately resorted by 'ORDER BY'
When an 'ORDER BY' clause exists, this sort order should remain until a new query is posted. Edited data should not be resorted immediately after posting a record - this behaviour interferes manual record changing (e.g. when copying a field value to the next record in the query result set).
This... more -
46 votes
Configuration option for ADS to use more system resources
Typically ADS will not consume too much of the system resources so as to allow other processes on the system enough resources to run properly. However, if the system was dedicated to ADS, it would be nice to configure ADS to be more selfish with resources to improve performance.
-
39 votes
-
33 votes
Make last statement in stored procedure be the result
Make last statement in stored proc be the result, no need to populate output table.
-
31 votes
Support for WindowsCE / Windows Mobile
Add support for .net compact framework
-
30 votes
Built in lookup fields for tables
Built in lookup fields for tables. User specifies source table, key field, etc. A writable dataset, but ignore updates to the lookup fields. Or some mechanism to make static cursors live in more situations, where we can make better decisions and try to resolve user record updates automatically.
-
29 votes
Automatically fix differences between table struct and dd
On DBF table open, check table structure vs data dictionary structure definition and adjust dictionary definition if different.
-
28 votes
command-line client like unixODBC isql (Linux, Windows)
Details (e.g., username, password, connection string) should be command-line parameters while SQL statements should come from stdin. That way I could either use it with a command-line prompt or redirect into it from .sql text files with scripts.
-
26 votes
OS Username Scalar Function
Would be useful to have a scalar function that returns the OS user login name, rather than the dictionary user name which is what USER() returns for dictionary connections. Perhaps add an option to the USER() scalar to alter its behavior in this way.
-
25 votes
Enum Field type
Many databases support an enumerated field type. It would be useful to be able to assign an Enumerated value, instead of storing numbers that translate to the selections.
i.e.
CREATE TABLE Info (
Relationship ENUM('self', 'spouse', 'guardian', 'other')
); -
24 votes
Add PDO Support (PHP-Data-Objects)
normal PHP driver are "ads_....()" funktions.
To generate portable PHP5 programs it's much better to use PHP data objects (PDO)
-
23 votes
TDataSet descendant dynamically load ace
This would allow for an executable to be deployed that uses the TDataSet Descendant components but that does not requiring the ACE DLLs. Usefull if exe is supporting multiple databases.
-
20 votes
Allow fts indexes on all data types
Allow fts indexes on all data types, integer, numeric, dates, money, etc. Then users can free search everything. It can be confusing right now because they see a grid with integer data, but when they do an fts search, they don't find those records.
-
19 votes
View only information for a specific database
In Advantage database manager one can see all connected users with all their open tabels and files etc for all databases on a server. It would be very handy to limit that to only those connected to a specifik database on the server. Likewise the option to disconnect the users from the server shou... more
