Skip to content

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

241 results found

  1. It would be great to have the existing component "TDADump" in UniDac for IBDac
    but with more functionality that would be "Update or Insert"
    this component could do export and import SQL data from one table to another table.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. A new component (MasterConnection) that uses master connection for read and write changes to DB , while uses slave connections to write and update only for online backup and fail safe recovery point.
    use case:
    An application can use local SQLite server for all operation (read and write) due the performance performance advantage ,while a remote MySQL server along with a Cloud SQL provider receive all and only all (write operations -insert/update/delete)

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Encryption parameters in SDAC Data
    It would be very very usefull to use Parameters on Insert and Update Queries

    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  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Change TOCICommand.InitProcParams7 MaxParams constant to 250

    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  ·  Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. As the "coInvertNullOrder" flag -for client side sorting the dataset- is already imlpemented for some of the providers, it would be nice to be able to control the default method how NULL values are sorted (comes as first or comes as last).

    The best approach would be to be able to control this over f.e. with an "IN" postfix in the IndexFieldNames, per field.

    Like: "SomeField DESC IN;OtherField ASC"

    Thx.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Please implement the support of AutoCreateMode in your components.

    Further description:
    http://docwiki.embarcadero.com/Libraries/Rio/en/Data.DB.TFieldOptions.AutoCreateMode

    With this option it's possible to create calculated fields in design time and all other fields will be added automaticly on runtime.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. They should have a component that easily imports data from excel, csv or text into a table and that supports large files.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Actually (v6.2.4), the PgDac TPgDump component does not generate appropriate code for inherited tables, making it useless when inherited tables are used, and we need to get the SQL script to generate the given schema.

    TPgDump should support tables inheritance and:
    - create base tables before inherited tables
    - use the inherits clause within the table creation sql statement
    - do not generate insert statements for base tables data, only for inherited tables

    Thanks,

    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  ·  PostgreSQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Connection Pooling should work in multi threaded environments with transactions.
    I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.

    Or can I download the source code for dbMonitor and edit it myself?

    thanks,

    Jon.

    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  ·  SQL Server  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. With PostGreSQL it is possible to specify multiple host components, each with an optional port component, in a single URI. A URI of the form

     postgresql://host1:port1,host2:port2,host3:port3/ 
    

    is equivalent to a connection string of the form

     host=host1,host2,host3 port=port1,port2,port3. 
    

    Each host will be tried in turn until a connection is successfully established.

    I'd like UniDAC to support this approach.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. When using batchUpdate, we have a total RowsAffected, but cannot know how many rows were affected by each individual parameter array item.
    So if you take different actions according to return value of RowsAffected, batchUpdates cannot be used.
    It would be nice to have a RowsAffectedArray (DynamicArray<__int64>, size = params.ValueCount) holding this value.

    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  ·  Common  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. I would like it to have a record limit setting that is the same or similar to what exists in FireDAC.
    This configuration and the behavior of FireDAC with this configuration would be nice to have in the Devart ODAC component.

    Here is an example of what exists in FireDAC:
    TFDQuery.FetchOptions.RecsMax := 100;

    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  ·  Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. For remote server with REST we need a FAST Json result from Db driver, direct, avoiding dataset marshalling.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Looking in the "UniDAC\Demos\ThirdParty\FastReport\" folder, I found a component: "TfrxUniDACComponents", which integrates Unidac with FastReport for Delphi, but I didn't find it for Lazarus. I'm using Lazarus 2.2.6 and would like to know if it's possible to develop this component for Lazarus as well.

    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  ·  UniDAC  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. In Postgres it's possible to create an readonly column,

    See
    https://www.postgresql.org/docs/current/sql-createtable.html

    GENERATED ALWAYS AS ( generation_expr ) STORED
    This clause creates the column as a generated column. The column cannot be written to, and when read the result of the specified expression will be returned.

    Automatic generated SQL for INSERT OR UPDATE don't handle the column as readonly. If you set UpdateAllFields to true an exception is raised. Also an exception occurs when you change the value of this field an call Post.

    The column should be set to readonly an the corresponding field should be excluded from INSERT andUPDATE.

    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  ·  PostgreSQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. replacement for BdeAdmin and TQuery.DatabaseName. Alias manager.

    3 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  ·  0 comments  ·  Common  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. From MyDAC for C++ Builder 5, I had to migrate from BDE to MyDAC by hand, the BDE only works on Delphi. We need a version that works for C++ Builder

    2 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  ·  MySQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?