Delphi Data Access Components

Delphi Data Access Components is a line of DB connectivity solutions for such databases as: Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, Microsoft Access, DB2, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

http://www.devart.com/dac.html

How can we improve our Delphi Data Access Components?

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Using TVirtualTable replace with TClientDataSet

    1.supports Aggregates
    2.supports Data And Delta!
    3.supports binary formatter data,like TClientDataSet!
    4.supports json data!
    5.supports SQL Memory.
    6.exports updated SQL!
    7.Supports Merge Delta Data,Reconcile Delta Data!
    8.Every record have Single row number,it can use to locate record!
    9.Supports DataSetField!
    10.Supports SetOptionalParam/GetOptionalParam

    279 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…)
      under review  ·  9 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
    • Encryption of the input and output parameters of stored procedures

      Шифрование входных и выходных параметров хранимых процедур.
      В IBDac есть возможность шифровать\расшифровывать на клиенте данные. Только с хранимыми процедурами это не работает.

      Encryption of input and output parameters of stored procedures. There is a capability in IBDAC to encrypt/decrypt data on the client. But it doesn't work with stored procedures.

      216 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…)
        under review  ·  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
      • Support Dev Express Grid Server mode

        Dev express have implemented a new server mode
        http://www.devexpress.com/Subscriptions/VCL/WhatsNewBuild12.1.3/index.xml?page=2#autolist1
        But it works only on ADO and DBexpress, perahaps you can work together to support unidac.

        165 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 →
        • Implementing UpdateOptions - TIBCQuery

          Two users modify the same field in the table,
          Error want to show the second user to save data.

          -) Using a TClientDataser and TDatasetProvider, no problem, works well.

          -) TFDQuery component FireDAC the Embarcadero it has the property
          Property: UpdateOpcions
          UpdateMode:
          upWhereAll
          upWhereChanged
          upWhereKeyOnly

          Implementing this property in TIBCQuery
          solve my problem of concurrency.

          thanks

          122 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  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
          • TIBCTransaction.OnEnd

            Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
            This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.

            104 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  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
            • TIBCQuery.OnScrollFinish

              Implement OnScrollFinish event that is fired at the end of the scrolling process.

              For example we need to adjust some elements of interface on record change, even perform an aditional sql query or other heavy calculations.

              For example, if user scroll fast over 20 records in a grid, relying on AfterScroll event imply a lot of unused work. So instead executing it 20 times, we may do this once after scroll process is finished.

              In fact, such kind of logic in *Dac already have it on Master/Detail "wait" magic, so it's not too much to change to have this kind…

              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…)
                2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
              • Improve data type mapping feature

                1. Allow set field type mapping / rules by CHARSET
                Ex: if db field charset is UTF8 set field as TWideStringField

                2. set field type mapping / rules by DOMAIN
                Ex: if db field domain is DM_BOOLEAN set field as TBooleanField

                3. [Optional] Separate TFieldMappings component that allow to define custom field mappings. T*Connection/T*Query should have a property of this type.
                Useful when use multiple connections (for example in threads), to define mapping rules once and link all Connections to one common component.

                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…)
                  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                • Implement COPY FROM/TO functionality

                  Implement COPY FROM/TO functionality for PostgreSQL (PgDAC component).

                  PostgreSQL COPY manual:
                  http://www.postgresql.org/docs/current/interactive/sql-copy.html

                  90 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  ·  PostgreSQL  ·  Flag idea as inappropriate…  ·  Admin →
                  • Firebird 3 Database Encryption Support

                    In Firebird 3.0 release there is an option to encrypt the whole database (http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-encryption.html).
                    For the encryption of the database you need a plugin (like this one that is working with AES128 from https://www.ibphoenix.com/products/software/encryptionplugin).
                    To open an encrypted database you just have to send the encryption key via a callback function "setDBCryptCallback" to the Firebird server.
                    My idea is if it's possible that the IBDAC component would be upgraded with the functionality to automaticly pass a setted "encryption_password" parameter (maybe there will be a need to have also a paramter for setting the Encryption library).
                    If you…

                    89 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  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                    • Save settings to the database as in an *.ini file or in registry

                      Many applications use TiniFile or TRegistry for saving their settings. However sometimes one user can work on several workstations with his login and password. He wants to have the same settings on all of his workplaces, and that settings, saved on one computer, were available on other ones.

                      To implement this feature we may add classes or components with interface similar to TiniFile or TRegistry that save data not on the local computer, but in a database.

                      80 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  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add a limit for the record count in the DataSet

                        Add a parameter, for example, MaxFetchRows, which will limit the number of records which can be fetched to the DataSet.

                        78 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…)
                          planned  ·  4 comments  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
                        • Better sql editor in Unidac

                          Uniquery sql editor editopr should be improved, showing Tables, fields and stored procedures with drag and drop (Fibplus like).

                          75 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  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
                          • Implement TStringField.Size restriction

                            DB table has column varchar(200), in application i want to restrict field size to 50 characters.
                            In ADO Components TStringField.size restrict string column size, but UniDAC, after open table, discard my TStringField.Size and set it to column size, that column has in DB.

                            70 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  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
                            • Create table in unidac

                              create table method which is database independend.

                              63 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  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add properties KeepAlive + KeepAliveInterval (maintain the connection)

                                The component should TUniConnection every 3000 ms (for example) to send to the server any single request (for example, "select 1 from dual"), to the gateway and the server is "seen" that the connection is active and the client is connected.

                                RUS:
                                Компонента TUniConnection должна, каждые 3000 мс (к примеру) отправлять на сервер какой-нибудь холостой запрос (к примеру, "select 1 from dual"), чтобы шлюз и сервер "видел", что соединение активно и клиент подключен.

                                Сообщение на форуме: http://www.devart.com/ru/forums/viewtopic.php?p=2081#2081

                                63 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  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
                                • Direct connection to 3050 Firebird port for IBDAC

                                  IBDAC should be able to connect directly to Firebird servers talking directly to port 3050 like ODAC does for Oracle. This would allow us to run our apps without installing Firebird client dll. It would also allow us to connect to Firebird Servers from iPads, iPods etc. (especially now that XE4 is out)

                                  55 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  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Creating a provider for ADO

                                    ADO access is included in some form in the SQLServer provider. Possibly it could extended to support other Ado providers/drivers. For example foxpro has ado driver till version 9, the odbc driver is at version 6. MSAccess is another example.

                                    49 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…)
                                      under review  ·  2 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Over-the-Wire (OTW) encryption for InterBase 2009

                                      Add support for Over-the-Wire (OTW) encryption for InterBase 2009

                                      48 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  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Adding the OnInfoMessage event for UniConnection

                                        Some of our DAC products support receiving information messages from database servers. (ToraSession and TMSConnection have the OnInfoMessage event, PgConnection has OnNotification event). We may add such event to TuniConnection; it will be called when a message from a database server is received.

                                        48 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  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Forced sending queries to the server without parameters

                                          Queries may be with or without parameters:

                                          select *
                                          from test_table
                                          where id = :ID

                                          or

                                          select *
                                          from test_table

                                          However some database servers execute queries without parameters faster than the same queries with parameters. An option (for example, AllowParams) may be added; if this option is set to False, all queries will be sent to a server as text.

                                          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…)
                                            4 comments  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 8 9
                                          • Don't see your idea?

                                          Delphi Data Access Components

                                          Feedback and Knowledge Base