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.

1. Top Ideas
2. Hot Ideas
3. New Ideas 2
4. Accepted Ideas 2
5. Completed Ideas 34

1. 21 votes

   vote

   How many 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)

   by Frank Leverenz | 2 comments
2. 3 votes

   vote

   How many votes?

   Subsonic Support

   SubSonic is A Super High-fidelity Batman Utility Belt that works up your Data Access (using Linq in v3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle.

   This tool looks at your database and generates classes based on your table design and allows you to... more

   SubSonic is A Super High-fidelity Batman Utility Belt that works up your Data Access (using Linq in v3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle.

   This tool looks at your database and generates classes based on your table design and allows you to quickly interact with your database in a true object orientated approach.

   by Jonathan Channon | 1 comment
3. 3 votes

   vote

   How many votes?

   Silent mode for adtfix utility

   Silent mode for ADT fix, always fix, no prompts and option for no backups.

   by jeremym1234 | 1 comment
4. 4 votes

   vote

   How many votes?

   Add low level text file support

   It would be great if ADS server could add low level binary file support, the equivalent of:

   FClose() - Closes a binary file.
   FCreate() - Creates an empty binary file.
   FErase() - Deletes a file from disk.
   FDelete() - Deletes one or more files specified by a file mask and file... more

   It would be great if ADS server could add low level binary file support, the equivalent of:

   FClose() - Closes a binary file.
   FCreate() - Creates an empty binary file.
   FErase() - Deletes a file from disk.
   FDelete() - Deletes one or more files specified by a file mask and file attributes.
   FOpen() - Opens a file on the operating system level.
   FRead() - Reads characters from a binary file into a memory variable.
   FReadStr() - Reads characters up to Chr(0) from a binary file.
   FRename() - Renames a file.
   FSeek() - Changes the position of the file pointer.
   FWrite() - Writes data to an open binary file.
   FCreate() - Creates and/or opens a binary file.
   FReadLine() - Extracts the next line from a text file.
   etc etc

   Many applications use the above in addition to dbfs/adts used for main storage

   by peterk@quicksoftware.co.za | 3 comments
5. 4 votes

   vote

   How many votes?

   Intellisense in debugger.

   by anonymous | 2 comments
6. 6 votes

   vote

   How many votes?

   'Total' command that work on server

   Total command that works on server like COPY. Using server speed, for reporting and other speed up aplication. I use many time indexing in runtime for reporting, with this speed indexing ,with diferent key depending on user query, my report is very speed. With total on server must be wery wery sp... more

   Total command that works on server like COPY. Using server speed, for reporting and other speed up aplication. I use many time indexing in runtime for reporting, with this speed indexing ,with diferent key depending on user query, my report is very speed. With total on server must be wery wery speed :) I work aplication with xBase++ and List&Label.

   by zoo | 0 comments
7. 0 votes

   vote

   How many votes?

   Architect 9.10.0.11 - Debug BUG

   If you create a breakpoint and step into the a script... i.e.

   declare c cursor as select * from table;
   declare i integer;

   open c;
   while fetch c do
   i = (select max(pk_id)+1 from table);
   if (i < 1) then
   i = 1;
   endif;
   update table set intfield = i where fieldx=c.fieldx;
   ... more

   If you create a breakpoint and step into the a script... i.e.

   declare c cursor as select * from table;
   declare i integer;

   open c;
   while fetch c do
   i = (select max(pk_id)+1 from table);
   if (i < 1) then
   i = 1;
   endif;
   update table set intfield = i where fieldx=c.fieldx;
   end while;

   If I step to the point where i is assigned and inspect the value then click the STOP button it doesn't actually stop. Instead execuition will continue, for a seemingly random amount of rows. At times it effects the entire table and others it stops at what appears to be a random row (not sure how random I didn't check, it might always 100 rows or something).

   by anonymous | 0 comments
8. 0 votes

   vote

   How many votes?

   Architect 9.10.0.11 - Debug BUG

   If you create a breakpoint and step into the a script... i.e.

   declare c cursor as select * from table;
   declare i integer;

   open c;
   while fetch c do
   i = (select max(pk_id)+1 from table);
   if (i < 1) then
   i = 1;
   endif;
   update table set intfield = i where fieldx=c.fieldx;
   ... more

   If you create a breakpoint and step into the a script... i.e.

   declare c cursor as select * from table;
   declare i integer;

   open c;
   while fetch c do
   i = (select max(pk_id)+1 from table);
   if (i < 1) then
   i = 1;
   endif;
   update table set intfield = i where fieldx=c.fieldx;
   end while;

   If I step to the point where i is assigned and inspect the value then click the STOP button it doesn't actually stop. Instead execuition will continue, for a seemingly random amount of rows. At times it effects the entire table and others it stops at what appears to be a random row (not sure how random I didn't check, it might always 100 rows or something).

   by anonymous | 0 comments
9. 6 votes

   vote

   How many votes?

   Python Client

   Create a client for use with Python.

   by anonymous | 0 comments
10. 5 votes

    vote

    How many votes?

    Add IF EXISTS syntax to DROP TABLE, ie. DROP TABLE IF EXISTS #list to "stop" exceptions

    This would be so useful (and I think) easy to implement...

    by anonymous | 4 comments
11. 3 votes

    vote

    How many votes?

    Field Level Access Rights Improvements

    Using the example of a table with name and salary fields (1) Remove the Field Level Access Rights on Salary for a_user (2) create an application with a grid and a dbEdit set the user to a_user and dbEdit to field salary. You cannot see the salary in the grid and If you try and change the salary... more

    Using the example of a table with name and salary fields (1) Remove the Field Level Access Rights on Salary for a_user (2) create an application with a grid and a dbEdit set the user to a_user and dbEdit to field salary. You cannot see the salary in the grid and If you try and change the salary field in the grid nothing happens. If you change the salary field in the dbEdit an exception occurs which you cannot get out of. Can you fully disconnect the protected fields so that if they are changed, the change is ignored as with the grid and no exception occurs?

    by PhilipLJackson | 0 comments
12. 1 votes

    vote

    How many votes?

    set default epoch

    by anonymous | 0 comments
13. 0 votes

    vote

    How many votes?

    Replication without Data Dictionary

    For legacy systems

    by anonymous | 0 comments
14. 0 votes

    vote

    How many votes?

    Add Mobilink support for device synchronization

    Add Advantage support to the iAnywhere Mobilink product to facilitate database synchronization from devices to an Advantage database.

    by jeremym1234 | 1 comment
15. 0 votes

    vote

    How many votes?

    ARC SQL Utility: Add ability to clear Messages

    In ARC SQL Utilitiy the compiler messages cannot be cleared. 'Select all - Cut' doesn't work. Please add ability to clear all compiler messages to the 'Clear all' button or to the compiler messages context menu.

    by ma1 | 0 comments
16. 6 votes

    vote

    How many votes?

    Advantage does not support "Select Into" a link db

    eg. Select * into LinkDB.Table1 from Table1 causes a SQL error. This is a very useful feature that allows one to quickly make a copy of an entire table (or selected record) from say a live database to a test/dev database.

    by Rafick | 0 comments
17. 0 votes

    vote

    How many votes?

    Get ADB template into Enterprise Architect by Sparx

    by anonymous | 0 comments
18. 5 votes

    vote

    How many votes?

    Execution plan on subqueries

    by anonymous | 0 comments
19. 1 votes

    vote

    How many votes?

    Correct a adt file that is delete but is not mark as deleted

    there are times when you remove a adt file from a dictionary, it is drop from the dB but is the free table reports it is still in a db the file then can not be accessed

    by rayhuff | 0 comments
20. 2 votes

    vote

    How many votes?

    the collation mismatches messages are super annoying

    by anonymous | 0 comments