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

Delphi Data Access Components

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded/refreshed already.
    Can you please add here any function, which can check it ?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  2. Hello,

    I'am testing multithreading with IBDac. For the moment the solution I have found is :
    1) Execute a TIbcquery in a thread
    2) Copy the result of 1) into a Memory Dataset (in the main thread) when 1) finished.

    I would like to know if it possible to do something like Firedac :
    https://delphi.programmingpedia.net/en/tutorial/4114/retrieving-updated-tdataset-data-in-a-background-thread
    or
    https://riptutorial.com/fr/delphi/example/14361/exemple-firedac

    The very interesting to transfer data between Query is the property :

    Form.FDQuery1.Data := Query.Data;

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  3. FillFieldsDefaultValues (in TCustomDADataSet.DataEvent) procedure is called everytime for a dataset, if Options.DefaultValues is True. It creates a query to get the default values. It might be a good idea to cache the defaults and avoid the query.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add support for Firebird 3 item iscdpbauthpluginlist and iscspbauthpluginlist. At the moment I am not able to specify what plugins are available to log in to Firebird 3.0 (Legycy_auth, Aug, Aug256)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  5. 24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  6. Please add support for FB 4.0 while it is still in beta or at least add support for the new FB data types so that developers could start using them in new applications.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support for the TDataset.FieldOptions property in IBDAC, specialy the AutoCreateMode so the TIBCQuery can add missing TFields automaticlly

    19 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
    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. TConnection/TQuery 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.

    108 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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…

    103 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  10. Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
    This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.

    111 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  11. Accessing firebird database from fastreport runtime designer
    using lazarus.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  12. FIBPlus have a great and simple way to quickly ask databse about value or set of values, this method is called QueryValue. If I want to ask database for only one row, I do not want to create a dataset for it. It causes a big overhead.

    Instead I would like to ask for a value like this:

    MyValue := Connection.QueryValue('SELECT TOP 1 USERNAME FROM USERS WHERE SURNAME = :SURNAME', [Surname])

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  13. Hello, I would appreciate (for easy migration from FIB+ to your component suite) adding OnFieldChange event and the CloneCurrentRecord.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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)

    66 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  15. Шифрование входных и выходных параметров хранимых процедур.
    В 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.

    225 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  16. Extract a whole table metadata information, like ibx / IBExtractExtractObject.
    It's useful for example replicate a table.

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  18. 20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  19. This will be controlled through an appropriate property.

    39 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?