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…)

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.

  1. 228 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      14 comments  ·  Flag idea as inappropriate…  ·  Admin →
      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.

    • 166 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        8 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • 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.

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

          71 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • 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
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              6 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                3 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • 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.

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

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

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

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

                        30 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          7 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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')
                          );

                          30 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • sql history

                              In ARC, like in TOAD or Oracle SQL developer, add a SQL history window or tab that recalls the past x SQL queries

                              27 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                jeremym1234jeremym1234 responded

                                Still want to do this, but no time on current schedule for it.

                              • Allow fts indexes on all data types

                                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.

                                23 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • One Time Synchronization to Begin Replication

                                  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.

                                  22 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    jeremym1234jeremym1234 responded

                                    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

                                  • Add system triggers

                                    Examples:
                                    User: OnLogin, OnLogout
                                    Dictionary: OnMetaDataChange
                                    Replication: OnReplicationError
                                    ...

                                    22 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • View only information for a specific database

                                      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 database

                                      22 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Add Table Type Option to CREATE TABLE

                                        Add option to let CREATE TABLE know which table type ADS should use. For example:

                                        CREATE TABLE mytable(field1...) IN DATABASE TYPE DBFCDX

                                        15 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                        • add ability to compile ads-php as php module under Linux

                                          Hello!
                                          It would be great to add the ability to compile ads-php as php module without recompiling whole php.
                                          It's very convenient to install / update php itself from binary repositories of modern Linux distributives, and only compile ads-php as php module from sources.
                                          Now it's something wrong with it.
                                          It can be compiled, but doesn't work with error like this:
                                          PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'advantage.so' in Unknown on line 0

                                          14 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 15 16
                                          • Don't see your idea?

                                          General

                                          Feedback and Knowledge Base