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. 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.

    223 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      under review  ·  0 comments  ·  InterBase/Firebird  ·  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

      127 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        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.

        108 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 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.

          105 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            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…

            101 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  InterBase/Firebird  ·  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)

              53 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  InterBase/Firebird  ·  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
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                • Executing SQL-Statement in Background (Interbase)

                  This will be controlled through an appropriate property.

                  36 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    under review  ·  2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                  • Implement compression to get most out of the FireBird 3

                    Firebird 3 supports the compression between client and server.

                    If possible implement this, it would make significant impact to the speed on slow connection (especially with large queries)

                    29 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                    • 20 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                      • Extract table metadata information

                        Extract a whole table metadata information, like ibx / IBExtractExtractObject.
                        It's useful for example replicate a table.

                        18 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                        • 15 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                          • Dbexpress Driver support compression for Firebird 3

                            Firebird over Internet is very slow, Firebird 3 solve this problem useing compress,please Implement Dbexpress Driver to support Firebird 3 compression

                            about firebird 3 compress :
                            http://www.firebirdnews.org/firebird-3-protocol-benchmark/

                            15 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                            • Fastreport support using lazarus

                              Accessing firebird database from fastreport runtime designer
                              using lazarus.

                              11 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                              • Adding OnFieldChange event and the CloneCurrentRecord.

                                Hello, I would appreciate (for easy migration from FIB+ to your component suite) adding OnFieldChange event and the CloneCurrentRecord.

                                12 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                • 10 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add Method CloneCursor for TUniQuery

                                    Add Method CloneCursor for TUniQuery like TClientDataset.CloneCursor

                                    9 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Display Computed fields values and exclude from SQL Generator

                                      I really like to see a new option in the TIBCQuery component to display the computed field automatically like the option defaultvalues

                                      Also to exclude all the table computed fields from insert and update SQLs automatically when using the SQL generator tab in TIBCQuery so I dont get errors about modifying read only dataset

                                      This small enhancement but will boost development time

                                      thanks
                                      Seems

                                      8 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Transaction should be closed when TIBCQuery (DataSet) is closed, and Transaction was started by that component. Same as IBX TIBTransaction.

                                        When I use TClientDataSet + TDataSetProvider + TIBCQuery and I open the ClientDataSet and also the TIBQuery is opend and closed, but the transaction is automaticlally started but not closed. In a n-tier solution (e.g. DataSnap) I open the ClientDataSet in the the client but have no access to the underlying Query and Transaction which is on the server side.

                                        The TIBTransaction has that feature implemented and is very handy to use.

                                        6 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Add threaded module to connect and performce SQL operations inside thread

                                          Currently when I tried to perform some SQL operation like connect or use filtersql for table the db bound control flashes and I get many errors like "system out of resource" , etc...

                                          I wish to see IBDac add a new special module to use as a holder for the IBDac components. this module can work inside a second thread but at the same can be bound to the main thread VCL UI controls....is that possible ?

                                          6 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Delphi Data Access Components

                                          Feedback and Knowledge Base