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

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

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

    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 →
  4. 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 →
  5. Currently TIBCLoader allows only to Load data by handling particular events. If I want to save something to database I need to handle OnPutData event. Unfortunately this solution requires usage of global variables because to know what I want to insert I need to look for some data beyond the scope of an event.

    Even the simple demo of yours shows this problem. You are using a global variable Count to know how much data you want to put it. Rest of the data you are using in a demo is random so it could be generated locally in the…

    4 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 →
  6. In FIBPLus we have Tr.TransactinID => number for new transaction after StartTransaction execution.

    4 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. 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 →
  8. It would be nice to have more control over display formats for Date and Numeric fields.
    So having a DefaultFormats property like FIBPlus has, would be of great value.

    FIBPlus implementation:
    DefaultFormats: TFormatFields;

    TFormatFields = class(TPersistent)
    DisplayFormatDateTime:string;
    DisplayFormatDate:string;
    DisplayFormatTime:string;
    DisplayFormatNumeric:string;
    EditFormatNumeric:string;
    ....
    end;

    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 →
  9. The component TIBCAlerter should have a property called Synchronize to listen for events in the background thread same like TFDEventAlerter component

    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 →
  10. My problem today.
    I developed a system that is going to be sold to many clients. The problem with firebird nowadays is that anyone can copy the database file and open it in its computer. Using SYSDBA and masterkey the database file can be opened in any computer and then, all your register can be copied.
    My dream would be that the user and password could be into the database file and not in the server. But I think this is so far away to come true.
    Then, I see a possibility to have all my strings rows encrypted, but…

    3 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 →
  11. Sometimes results is to big to be save or more often to be loaded into a tVirtualTable (not enough memory). Solution should be to split the result files into several smaller ones (according to line numbers or size).

    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 →
  12. Возможность выполнять запросы в локальном кеше при установке
    значения IBCQuery->LocalUpdate=true

    1 vote
    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. I would like complete control on how the parenthesis are added to the where clause. The way they are added now, it can result in a where clause that won't return what you're looking for.

    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 →
  14. 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 →
  15. 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 →
  16. inidac page claims multiple transaction supports. IBDAC is rumored to be slcie of UniDAc but it does not claim overlapped and evenmere nested transactions support at http://www.devart.com/ibdac/features.html

    I think that should be stated clearly whether this feature been removed from IBDAC or stays there.

    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 →
2 Next →
  • Don't see your idea?