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 support and comment on it.

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

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

  1. 1 vote
    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 →
    • ADS 12.x and Windows Server 2016 Support

      Can you certify the use of the ADS12 version with Windows 2016 server?

      3 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 →
      • Single record view with vertical scrollbar in Advantage Data Architect for selected record in a SQL-query resultset.

        Single record view with vertical scrollbar in Advantage Data Architect for selected record in a SQL-query resultset.

        1 vote
        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 →
        • Advantage Crystal Reports Driver for Windows 64-bit (crdb_ads.dll)

          Advantage Crystal Reports Driver for Windows 64-bit (crdb_ads.dll) needed.

          Can you compil the Advantage Crystal Reports driver in 64-bit version?

          Switching datasources from the Advantage Crystal Reports Driver to ODBC/OLEDB 64-bit in our Crystal Reports is not an option.

          3 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 →
          • 1 vote
            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 →
            • After updating to ADS 12 queries with some FoxPro DBF tables do not work

              Here's an error:

              poQuery: Error 7200: AQE Error: State = HY000; NativeError = 3207; [SAP][Advantage SQL Engine][ASA] Error 3207: Unsupported function found in index Conditional expression. Table name: MDOCM

              Here's a query: Select * FROM MDOCM

              Here's a table: https://www.dropbox.com/s/kw7lqfxjwxw5gy7/mdocm.zip?dl=0

              (FoxPro DBF, CDX, OEM, Russian)

              Here's connection settings, that worked well in prev.versions:
              http://ds.3kota.by/5mmVa.png

              It's not the only table with this error - I have same issues with many other DBF tables, too

              It was ok in ver.9 and I also tried in demo versions of 10.10 - it was also ok.

              If table is already added to a dictionary…

              1 vote
              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 →
              • Apply Table view filter on Enter

                If I open a table and enter a filter like ID = 123, I'd like to make Apply Filter a default button, when I enter Filter field. So hitting Enter key would Apply it.

                1 vote
                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 →
                • ARC Table view filter should understand IN and LIKE operators

                  Now ARC can only apply single field filter to table view: http://ds.3kota.by/NcfRY.png
                  if I use IN or LIKE operator I get an error. However in some cases it's the inly way of working way of fixing DB duplicate records. In some cases this should be done quickly and manually. I can write a query to filter them, but I can't delete records manually with a VIEW.

                  1 vote
                  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 →
                  • AdsConnection Error 7008 or 7200

                    Hello guys,

                    I use Delphi 2010 and ADS 10.00.0.3

                    Always where I need to debug the source code, I have to copy the database to the same PC where the source code.

                    The reason is that always returns the error 7200.

                    The most common mistake is 7008.

                    In the same my application folder is the Ads.ini file with the following content:

                    [Databases]
                    SAVE80 = \\ 192.168.1.60 \ Data; A

                    In AdsConnection1 component in ALIASNAME property also put SAVE80.

                    See the path \\ 192.168.1.60 \ data is pointing to the server where the database.

                    When compiling my application is returning the…

                    1 vote
                    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 →
                    • Advantage Data Architect

                      There are two features that you've taken away that we desperately need back. Most importantly is the "respect when counting" option to accrately return the record count when applying filters. We use that all the time when testing data conversion filters, and are hanging on to old ADS Data Architects for just that purpose. Also, the drop-down calendar makes entering timestamp information impossible, as one cannot enter seconds or hundredths, and there seems to be no way to turn off the calendar or alter the mask. Again - we can't use the newer Data Architect because we have to be…

                      1 vote
                      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 →
                      • IPv6 support

                        This is 2016 and many are moving to IPv6 on the LAN before on the WAN. An application that doesn't work via IPv6 is a roadblock. ADS has to be able to communicate via network and without IPv6 support that's impossible in certain circumstances.

                        5 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 →
                        • User Defined Aggregate Functions

                          I need to be able to do aggregate operations other than the (very) limited collection included. For example, the state I work in requires us to report a certain field using a format like:

                          Manowar|Jellyfish|Cod|Eel

                          where each of the animals comes from a single database row. This means that I have to aggregate the four animals into a single data-point by concatenating strings. Which is currently impossible using Advantage Database. (This is equivalent to Oracle's `listagg` function)

                          I get that most people wouldn't be interested in using this particular aggregate function, and that SAP developer time shouldn't be wasted on…

                          3 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 →
                          • Enable exporting to a spreadsheet within an sql.

                            Enable exporting to a spreadsheet within an sql. Presently have to rightclick within data. Enabling would promote automation.

                            1 vote
                            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 →
                            • IP Version 6 Support

                              Add support for IP Version 6.

                              Product such as DirectAccess VPN which is used by large corporate companies to provide a simple VPN access without any user interaction will only work with IPv6 aware applications, preventing applications that use ADS from working.

                              3 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 →
                              • adjust SQL query

                                Hello,

                                I think there is a bug in ads 11.10.0.24 and perhaps in newer versions.
                                I have two very large tables A and B both with fields id (integer and id>0)

                                When I execute:

                                SELECT A.id FROM A
                                WHERE A.id NOT IN (SELECT B.id FROM B)

                                I get no result and I know there has to be a result.

                                When I execute

                                SELECT A.id FROM A
                                WHERE A.id NOT IN (SELECT B.id FROM B WHERE B.id > 0 )

                                I get the good result.
                                So not using the WHERE there is no result.

                                Best regards,
                                Frans Laenen

                                1 vote
                                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 →
                                • Create a backup of Databases with encrypted tables, without entering the password

                                  It isn't possible to create backups without having the password.
                                  That makes it impossible for Sys-admins to use the backup feature of ARC, if they aren't given the password from the Software Company.
                                  But they shouldn't be able to alter the table, so giving out access isn't an option

                                  1 vote
                                  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 →
                                  • Better use of multifield indexes under SQL

                                    Given an index under ADT format of say SKU;Quantity

                                    The following select is full optimized
                                    SELECT * from inventory where SKU=Z and qty = 0

                                    but this is not
                                    SELECT * from inventory where SKU=Z and qty > 0

                                    unless I add an additional index based on quantity only, other SQL servers do not need the additional index

                                    1 vote
                                    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 →
                                    • Full Java Persistence API (JPA) Support (EclipseLink, Hibernate)

                                      Full Java Persistence API (JPA) Support (EclipseLink, Hibernate)

                                      (We use EclipseLink)

                                      • Reading the Metadata from dbf-Files

                                      • Autocreate and autoupdate the Tables:

                                      eclipselink.ddl-generation : create-or-extend-tables

                                      hibernate.hbm2ddl.auto : update

                                      252 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 →
                                      • Make binary compression compress any data included, not just

                                        Make binary compression compress any data included, not just plain text.

                                        1 vote
                                        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 →
                                        • Backup Software!!

                                          You can take File backup using "Cloudbacko home" software by this you can actually take backup that helps restoring as well. This backup software gives backup to large files and helps restoring also. Leaving a link below just check: http://www.cloudbacko.com/free-backup.jsp

                                          3 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 →
                                          ← Previous 1 3 4 5 17 18
                                          • Don't see your idea?

                                          General

                                          Feedback and Knowledge Base