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.

    224 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    129 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  3. TIBCTransaction.OnEnd

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

    109 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    106 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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…

    102 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  7. Over-the-Wire (OTW) encryption for InterBase 2009

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

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  8. Executing SQL-Statement in Background (Interbase)

    This will be controlled through an appropriate property.

    39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  10. 20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  12. 15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  14. Fastreport support using lazarus

    Accessing firebird database from fastreport runtime designer
    using lazarus.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  16. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add Method CloneCursor for TUniQuery

    Add Method CloneCursor for TUniQuery like TClientDataset.CloneCursor

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    (thinking…)
    Sign in with: Facebook Google
    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