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
4. Accepted Ideas 1
5. Completed Ideas 40

1. 1 votes

   Advantage data architect - error with mouse wheel (when scrolling)

   Lets open a simple database with an index; if you use the mouse wheel, suddenly appears at the bottom a subset of records with duplicated info, in as many groups as values has the indexkey.
   It would be more easy to explain if I could send an image of the screen and the database with which it fai... more

   Lets open a simple database with an index; if you use the mouse wheel, suddenly appears at the bottom a subset of records with duplicated info, in as many groups as values has the indexkey.
   It would be more easy to explain if I could send an image of the screen and the database with which it fails.
   My version is 9.10.0.21
   Regards,

   by Claudio Voskian | 0 comments

   Status: completed

   Hi Claudio, go ahead and send in the files and screenshots to advantage@iAnywhere.com and put "attn:JD" in the subject. Thanks for reporting the issue!

   jeremym1234 Admin
2. 2 votes

   Trim the code of stored procs and triggers in the dictionary comparer

   The dictionary compare tool shows a difference between two identical stored procedures / triggers when they have extra spaces at the beginning or at the end.

   The code should be trimmed on both sides.

   by J. Mühlenhoff | 0 comments

   Status: completed

   Thanks for your feedback. This is a known bug and was fixed in version 9.10.0.21 and is scheduled to be fixed in the next 10.0 update (in a few weeks).

   jeremym1234 Admin
3. 3 votes

   arc32 multi screen

   Hi
   With my portable I often switch between single and dual screens depending if I am on the road or in the office. If I close arc32 when in dual screen mode and then open it again when I only have the laptop screen acr32 opens but is not visible and I have great difficulty in getting it to show... more

   Hi
   With my portable I often switch between single and dual screens depending if I am on the road or in the office. If I close arc32 when in dual screen mode and then open it again when I only have the laptop screen acr32 opens but is not visible and I have great difficulty in getting it to show on the only screen I have. Any chance you can test how many screens are available and open it on the first screen if there is only one?

   Regards

   by PhilipLJackson | 1 comment

   Status: completed

   Will be in first v10 service update and next 9.1 service update.

   jeremym1234 Admin
4. 0 votes

   Architect 9.10.0.11 - Remote Management Utility

   If you open the remote management utility window and it's previous state was maximized it flickers as it's painted. Also, it takes about 2-3 seconds to be fully displayed. If the previous status was a window it doesn't flicker and opens immediately.

   by anonymous | 2 comments

   Status: completed

   This will be fixed in v10 and the next v9.1 service update.

   jeremym1234 Admin
5. 3 votes

   Highlight deleted records

   Would be great to see deleted records highlighted in the Advantage Data Architect.

   by Tommysimo_ST | 1 comment

   Status: completed

   I agree. This is in version 10 of ARC (beta this week).

   jeremym1234 Admin
6. 3 votes

   Allow NULL values to bootstrap a column alias

   Currently, one can bootstrap an alias with a literal value, one cannot do the same with NULL. Please allow NULL to be used as well since it is a valid option.

   For example you can do the following:

   Select 'ABC' as ColumnName from system.iota;

   BUT cannot do:

   Select NULL as ColumnName f... more

   Currently, one can bootstrap an alias with a literal value, one cannot do the same with NULL. Please allow NULL to be used as well since it is a valid option.

   For example you can do the following:

   Select 'ABC' as ColumnName from system.iota;

   BUT cannot do:

   Select NULL as ColumnName from system.iota;

   This is rather annoying. I had to write a function that returns NULL to overcome this limitation.

   by ahinson | 1 comment

   Status: completed

   Closing. See Alex's reply.

   jeremym1234 Admin
7. 1 votes

   Add simple "LIMIT nnn" syntax (as well as TOP) to improve compatability

   by anonymous | 1 comment

   Status: completed

   We have added the START AT clause to our TOP X functionality. For example you will be able to execute the following:
   SELECT TOP 2 START AT 6 *
   FROM Employees
   ORDER BY Surname DESC;

   jeremym1234 Admin
8. 10 votes

   ADD LIMIT PARAMETER

   I'm working with very large table and i net to show only parts of records

   by anonymous | 2 comments

   Status: completed

   We have added the START AT clause to our TOP X functionality. For example you will be able to execute the following:
   SELECT TOP 2 START AT 6 *
   FROM Employees
   ORDER BY Surname DESC;

   jeremym1234 Admin
9. 7 votes

   temporarily perform operations outside of transaction

   Allow specific operations to be done ouside of the current transaction context. For example if you want to update a status table and have other users see your changes before you current transaction is committed, this would be very helpful.

   by jeremym1234 | 0 comments

   Status: completed

   Allowing specific tables to be excluded from transactions.

   jeremym1234 Admin
10. 9 votes

    Add .NET Entity Framework 4.0 Support

    Changes are huge in the EF for .NET 4.0. I think supporting this is very important, as many think that 4.0 is the first serious release of EF.

    by Eric Harrelson | 1 comment

    Status: completed
11. 28 votes

    Return query-specific row number.

    Something similar to "ROWNUM" in Sybase or "ROW_NUMBER()" in MS SQL. Could be used with "SELECT TOP" to mimic PostgreSQL/ MY SQL "LIMIT/ OFFSET" paginations.

    by kierandarcy | 0 comments

    Status: completed
12. 57 votes

    New SQL-Function IsoWeek

    I would like to have a Function which calculats the week-number in the ISO8601 way (31. december 2007 is week 2008/01)

    by Tyrolean | 0 comments

    Status: completed
13. 77 votes

    unicode field type

    by jeremym1234 | 3 comments

    Status: completed

    This would include char, varchar and memo support.

    jeremym1234 Admin
14. 3 votes

    64-bit Linux libace.so!

    Since it looks like I'm not going to get my 64-bit Linux command-line client I decided to develop my own. But wait! I can't because . . . there is no 64-bit libace.so! Is it used internally but not shared? I don't need tech support.

    by PRosario | 1 comment

    Status: completed

    Planned to be part of the v10 release in the first half of 2010.

    jeremym1234 Admin
15. 7 votes

    Need a 64bit OLE DB Driver

    Cannot create a linked server using 64bit SQL Server without a 64bit OLE DB Advantage Driver. As more and more companies migrate to 64bit windows, O/S integration with MS will not be possible without downgrading. Advantage should integrate into the enterprise and not be isolated from advancements... more

    Cannot create a linked server using 64bit SQL Server without a 64bit OLE DB Advantage Driver. As more and more companies migrate to 64bit windows, O/S integration with MS will not be possible without downgrading. Advantage should integrate into the enterprise and not be isolated from advancements in technology and the trend in server technology moves beyond 32bits.

    by Bradley Bell | 0 comments

    Status: completed

    Planned to be part of the v10 release in the first half of 2010.

    jeremym1234 Admin
16. 9 votes

    64-bit Linux ODBC driver!

    I imagine all this would take is the same source code with a new compiler switch. Of course, I wouldn't need this if there was a 64-bit Linux command-line client!

    by PRosario | 0 comments

    Status: completed

    Currently planned to be part of the v10 release in the first half of 2010.

    jeremym1234 Admin
17. 26 votes

    Compiled sql script triggers and procs

    Compiled (as opposed to interpreted) scripts for better performance.

    by jeremym1234 | 1 comment

    Status: completed

    We did not end up precompiling the scripts, but we did implement a variety of changes that have significantly improved stored procedure performance (in par with our UDFs, which have always been much faster). Planned to be part of the v10 release the first half of 2010.

    jeremym1234 Admin
18. 1 votes

    Allow sql keyword "join" to refer to "inner join"

    "inner join" is the most commonly used join in sql statements. Allow just the word "join" to refer to an "inner join" will cut down the time to type sql statements. This syntax is also supported by MS SQL Server and will cut down the time for users of MS SQL Server t... more

    "inner join" is the most commonly used join in sql statements. Allow just the word "join" to refer to an "inner join" will cut down the time to type sql statements. This syntax is also supported by MS SQL Server and will cut down the time for users of MS SQL Server to migrate their SQL statements to ADS.

    by Rafick | 3 comments

    Status: completed

    Looks like this was already implemented in ADS v9.0

    jeremym1234 Admin
19. 2 votes

    adsCloneConnection

    Function to get a new connection handle with the same rights like the origin without having to take care of username/password. Useful for initiating a new connection for a new thread

    by Marcus Herz | 0 comments

    Status: completed

    I needed this functionality in ARC recently, so v10 of Advantage should have a constructor called CreateFromHandle which can be used like so:

    NewConn := TAdsConnection.CreateFromHandle( nil, ExistingConn.Handle );

    jeremym1234 Admin
20. 10 votes

    Fix the DataDictionary Compare Tool

    In many cases the tool will create SQL that isn't valid. In some cases this is because it's create a command that is dependent on another yet appears before it.

    Also, it should do a better job aggregating command based on command and table. For example:
    ALTER TABLE [Table Name]
    ALTE... more

    In many cases the tool will create SQL that isn't valid. In some cases this is because it's create a command that is dependent on another yet appears before it.

    Also, it should do a better job aggregating command based on command and table. For example:
    ALTER TABLE [Table Name]
    ALTER COLUMN [Column Name] [Column Name] Char( 10 ) POSITION 1;
    ALTER TABLE [Table Name]
    ALTER COLUMN [Column Name] [Column Name] Char( 10 ) POSITION 2;

    should be aggregated to:

    ALTER TABLE [Table Name]
    ALTER COLUMN [Column Name] [Column Name] Char( 10 ) POSITION 1
    ALTER COLUMN [Column Name] [Column Name] Char( 10 ) POSITION 1;

    and adding columns to be handled similarly:

    ALTER TABLE [Table Name]
    ADD COLUMN [Column Name] Char( 10 ) POSITION 1
    ADD COLUMN [Column Name] Char( 10 ) POSITION 2;

    by anonymous | 2 comments

    Status: completed