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. 27 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)
  2. Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc

    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  ·  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)
  3. UniDAC currently only supports OpenSSL 1.0.2. This version won't be supported past 2019-Dec-31.

    To avoid problems UniDAC should support OpenSSL 1.1

    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  ·  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)
  4. Your implemantation of cached updates with Updatebatchsize is super fast in comparison to firedac. But sometimes we need to see query delta to apply changes to other datasets without using stored procedures.

    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  ·  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)
  5. Include SQLite extensions like enable FTS5 in direct mode connection in UniDac.

    5 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  ·  SQLite  ·  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. 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Fast Report in Lazarus frxODACComponents is not included in the set of our componente when using the Lazarus environment

    58 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 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)
  8. 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)
  9. Add Async notifications support to OraQueue in Direct mode.

    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  ·  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)
  10. SQL Server now has a new security feature called "Always Encrypted". This is a recognised Microsoft solution for encrypting certain sensitive database columns to meet European Union GDPR regulations. Please add "Always Encrypted" support into Devart SQL Server data access components. This is a recognised approved solution to SQL Server DBA's.

    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  ·  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)
  11. У компонентов FIBPlus есть замечательная фича.
    Когда в базе (Firebird) меняешь размер поля, то не нужно корректировать этот размер у DataSet компоненты. Компонента (TpFibDataSet) сама подтянет новый размер поля в дизайнтайме.
    Было бы здорово, чтобы компонента TUniQuery тоже такое умела.
    Вообще, желательно, чтобы подгружался не только размер поля, а и другие параметры и не только текстового.
    Я работаю с UniDAC примерно с 2012 г и удивлён, что этой фичи ещё нет.
    У FIBPlus много вкусного, жаль, что они больше не развиваются.

    Под словом "подтягивать" я имел ввиду брать из базы, из системных таблиц читать разные параметры поля и применять их…

    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  ·  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)
  12. Я знаю, что у TUniQuery есть возможность сгенерировать доп. запрос на основе SelectSQL.
    Но это неочевидно, в справке нет. Нет готовых методов.
    Приходится открывать предварительно сам запрос, что есть не совсем правильно.

    [code] UniQuery1.Open;
    UniQuery1.SQLUpdate.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stUpdate, true);
    UniQuery1.SQLRefresh.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stRefresh, true);
    [/code]
    да и без UniQuery1.Open вываливается AV :(

    Было бы здорово, если бы было что-то вроде:
    UniQuery1.GelerateAllSQLs.
    UniQuery1.GelerateInsertSQL;
    UniQuery1.GelerateUpdateSQL;
    UniQuery1.GelerateDeleteSQL;
    и т.д.
    и без обязательного открытия набора данных.

    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  ·  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)
  13. TMyDump.Backup() writes all Views in alphabetical order. However, if there are inter-joins among Views the database may not be restored, as the Views must be restored according to their dependencies.

    I strongly suggest fixing TMyDump.Backup. The algorithm should analyze the dependencies among Views and account for the correct order of joins.

    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  ·  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)
  14. The ODBC-provider for ADS has some restrictions, for example can't access encrypted free tables).
    Also FireDac has already an native provider for ADS.

    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  ·  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)
  15. Implementation of the new authentication method of newer Microsoft SSMS:
    * Active Directory – Universal with MFA support
    * Active Directory - Password
    * Active Directory - Integrated

    48 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)
  16. 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)
  17. Unidac connectionstring add parameter column encryption setting=enabled

    12 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  ·  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)
  18. 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)
  19. "CockroachDB is a cloud-native SQL database for building global, scalable cloud services that survive disasters."

    https://github.com/cockroachdb/cockroach

    16 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  ·  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. 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)
  • Don't see your idea?