General

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.

Feedback:

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the “My feedback” filter and select “My open ideas”.
(thinking…)
Reset

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
    1. 207 votes
      Vote 0 votes Vote Vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service

        You'll receive a confirmation email with a link to create a password (optional).

        Signed in as (Sign out)
        You have left! (?) (thinking…)
        jeremym1234jeremym1234 responded

        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.

      • 176 votes
        Vote 0 votes Vote Vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service

          You'll receive a confirmation email with a link to create a password (optional).

          Signed in as (Sign out)
          You have left! (?) (thinking…)
          started  ·  jeremym1234jeremym1234 responded

          Design is almost complete, implementation starts soon! :)

        • 149 votes
          Vote 0 votes Vote Vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service

            You'll receive a confirmation email with a link to create a password (optional).

            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • 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.

            92 votes
            Vote 0 votes Vote Vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service

              You'll receive a confirmation email with a link to create a password (optional).

              Signed in as (Sign out)
              You have left! (?) (thinking…)
              started  ·  2 comments  ·  Admin →
            • 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

              68 votes
              Vote 0 votes Vote Vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service

                You'll receive a confirmation email with a link to create a password (optional).

                Signed in as (Sign out)
                You have left! (?) (thinking…)
              • 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.

                67 votes
                Vote 0 votes Vote Vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service

                  You'll receive a confirmation email with a link to create a password (optional).

                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • 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.

                  60 votes
                  Vote 0 votes Vote Vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service

                    You'll receive a confirmation email with a link to create a password (optional).

                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • 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 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
                    Vote 0 votes Vote Vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service

                      You'll receive a confirmation email with a link to create a password (optional).

                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • Make last statement in stored procedure be the result

                      Make last statement in stored proc be the result, no need to populate output table.

                      45 votes
                      Vote 0 votes Vote Vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service

                        You'll receive a confirmation email with a link to create a password (optional).

                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        planned  ·  6 comments  ·  Admin →
                      • MySQL style dump scripts as a server side backup option

                        The ability to generate a SQL dump of the entire database (minus blobs etc) from the server would be an excellent backup option.

                        39 votes
                        Vote 0 votes Vote Vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service

                          You'll receive a confirmation email with a link to create a password (optional).

                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • 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.

                          38 votes
                          Vote 0 votes Vote Vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service

                            You'll receive a confirmation email with a link to create a password (optional).

                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • 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.

                            37 votes
                            Vote 0 votes Vote Vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service

                              You'll receive a confirmation email with a link to create a password (optional).

                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                            • 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.

                              35 votes
                              Vote 0 votes Vote Vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service

                                You'll receive a confirmation email with a link to create a password (optional).

                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                              • Add more information to ADS error messages!

                                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.

                                31 votes
                                Vote 0 votes Vote Vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service

                                  You'll receive a confirmation email with a link to create a password (optional).

                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • Ability to manually update the progress callback

                                  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;

                                  30 votes
                                  Vote 0 votes Vote Vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service

                                    You'll receive a confirmation email with a link to create a password (optional).

                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                  • 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')
                                    );

                                    29 votes
                                    Vote 0 votes Vote Vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service

                                      You'll receive a confirmation email with a link to create a password (optional).

                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                    • 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
                                      Vote 0 votes Vote Vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service

                                        You'll receive a confirmation email with a link to create a password (optional).

                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                      • Add Database Monitor Email Alerts

                                        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 queries

                                        28 votes
                                        Vote 0 votes Vote Vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service

                                          You'll receive a confirmation email with a link to create a password (optional).

                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                        • 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.

                                          27 votes
                                          Vote 0 votes Vote Vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service

                                            You'll receive a confirmation email with a link to create a password (optional).

                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                          • 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)

                                            27 votes
                                            Vote 0 votes Vote Vote
                                            Vote
                                            Sign in
                                            Check!
                                            (thinking…)
                                            Reset
                                            or sign in with
                                            • facebook
                                            • google
                                              Password icon
                                              I agree to the terms of service

                                              You'll receive a confirmation email with a link to create a password (optional).

                                              Signed in as (Sign out)
                                              You have left! (?) (thinking…)
                                              started  ·  2 comments  ·  Admin →
                                            ← Previous 1 3 4 5 6 7 8 9 10 11 14 15
                                          • Don’t see your idea?
                                          • Post a new idea…
                                          • General

                                            Knowledge Base and Helpdesk