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.
Full Java Persistence API (JPA) Support (EclipseLink, Hibernate)
(We use EclipseLink)
• Reading the Metadata from dbf-Files
• Autocreate and autoupdate the Tables:
eclipselink.ddl-generation : create-or-extend-tables
hibernate.hbm2ddl.auto : update112 votes
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.105 votes
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 Triggers71 votes
It would be fine when the AOF (of a TADSTable) could have the same Syntax like the SQL-Where-Part of a TADSQuery.67 votes
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 issue should be solved at least for temporary indexes with 'ORDER BY' by introducing an Option 'Fixed' for those indexes or, even better, making this the default behaviour (like MySQL etc.).47 votes
Most ADS error messages dealing with table problems (7000 series) do not include much information. Would be nice to have other data included such as table name, record number, field name, etc, depending on the type of error.44 votes
The ability to generate a SQL dump of the entire database (minus blobs etc) from the server would be an excellent backup option.41 votes
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.37 votes
My request would be to provide the same functionality that SQL Anywhere is working in beta right now...
The ability to send email alerts warning of Bad Things Happening to your "SQL Anywhere" database server is the release-defining feature of the new SQL Anywhere Server Monitor now available in beta.
The monitor lets you pick and choose what you want to be warned about and also set values for each metric:
- CPU Usage
- Memory Usage
- Disk Usage
- Connections being blocked
- Connection count
- Long running queries33 votes
When processing data in a stored procedure or script using a while loop in order to report the real progress of the actual script instead of getting progress on each query execution. See example below.
DECLARE Query cursor;
OPEN Query as select * from SYSTEM.TABLES; WHILE FETCH Query DO
--Update Statement 1
--Update Statement 2
--Manually Increment Progress Callback
END WHILE;31 votes
On DBF table open, check table structure vs data dictionary structure definition and adjust dictionary definition if different.30 votes
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.
CREATE TABLE Info (
Relationship ENUM('self', 'spouse', 'guardian', 'other')
In ARC, like in TOAD or Oracle SQL developer, add a SQL history window or tab that recalls the past x SQL queries29 votes
Still want to do this, but no time on current schedule for it.
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.25 votes
Have an initial synchronization option when replication is enabled/configured so that the database doesn't have to be manually copied. Make it easier to deploy replication.24 votes
I think this is a good idea too. Joachim also has suggested as a work-around for now that you can (in 9.0 and newer) set the publication up to use the new MERGE statements, then use a script that just touches each record on the source but doesn’t change it. Something like UPDATE table SET id = id
User: OnLogin, OnLogout
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 should also support only to disconnect the user from a particular database22 votes
Add option to let CREATE TABLE know which table type ADS should use. For example:
CREATE TABLE mytable(field1...) IN DATABASE TYPE DBFCDX15 votes
- Don't see your idea?