Skip to content
← Customer Feedback for Devart

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

(thinking…)

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

37 results found

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Natural sort for IndexFieldNames (order 1, 2, 11 instead of 1, 11, 2)

    You can order your query/table with the property IndexFieldNames. But if you have an varchar field that contains numbers, the order is wrong. You get:

    1
    11
    2

    But better would be:
    1
    2
    11

    This can be done with the "natural sort" algorithm. Please implement it for the use with IndexFieldNames like:

    ATable.IndexFieldNames := 'MyField natural';

    I know I could sort it with SQL, but I need client side sorting with the property IndexFieldNames.

    For natural sort see:
    https://en.wikipedia.org/wiki/Natural_sort_order

    (As far I know Windows uses StrCmpLogicalW to sort file names in that way)

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Implement Connection.QueryValue()

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Extend TIBCLoader beyond event driven design when loading data.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Multithreading : Copy data from query

    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;

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. To Know what is the Number for new Transaction ( TransactionID)

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. DataSet memory Container

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. TIBCAlerter.Synchronize property

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. Add DefaultFormat property to TIBCQuery for Date and Numeric fields.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. DetailDelay - DetailLoaded - status in Detail table

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. SaveToXml method from tIBCStoredProc or tQuery splited into several files

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. the ability to perform sql queries in the local cache

    Возможность выполнять запросы в локальном кеше при установке
    значения IBCQuery->LocalUpdate=true

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Eliminate parethesis when using AddWhere

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. IBDAC - is there multiple overlapping transactions support ?

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. Support for Firebird 3 item isc_dpb_auth_plugin_list

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
2 Next →
  • Don't see your idea?