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. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 77 votes

   unicode field type

   by jeremym1234 | 3 comments

   Status: completed

   This would include char, varchar and memo support.

   jeremym1234 Admin
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 2 votes

    adjustable row height in data architect

    1. How about allowing adjustable row heights is Data Architect when browsing data and/or font size.

    2. How about adjustable font sizes for memo editing/viewing windows when browsing data.

    Similar to editor options.

    by wilfred.oluoch | 1 comment

    Status: completed
16. 3 votes

    Flag tables to stay in cache

    ability to for users to flag a table as always being cached (if they know they only need it readonly).

    by jeremym1234 | 0 comments

    Status: completed
17. 5 votes

    .net membership providers

    Implement .NET membership providers

    by jeremym1234 | 1 comment

    Status: completed
18. 5 votes

    Make Architect Help Files Vista Compatible - Not .hlp

    .hlp files are not longer supported by Vista w/o installing a patch from Microsoft. It would nice if they were html, xml, or chm based, which are supported by default.

    by ahinson | 1 comment

    Status: completed

    Agreed. We've bought new help authoring software and this task is a work in progress.

    jeremym1234 Admin
19. 0 votes

    How about some .net samples on the Dev zone using Crystal Driver?

    There are no examples using the Crystal Reports driver in any language. I'd prefer to see some using a .net language (VB.net/C#).

    Also, in general there's very little documentation for all of your products, with the exception of a few code samples there's no documentation describing how to ... more

    There are no examples using the Crystal Reports driver in any language. I'd prefer to see some using a .net language (VB.net/C#).

    Also, in general there's very little documentation for all of your products, with the exception of a few code samples there's no documentation describing how to use them or what they do. How about some msdn style pages on your site for each application describing what they do and how to use them - it's 2009 not 1998.

    by anonymous | 1 comment

    Status: completed
20. 5 votes

    Support Nested Transactions

    by jeremym1234 | 0 comments

    Status: completed