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

71 results found

  1. 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)
  2. У компонентов 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)
  3. Я знаю, что у 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)
  4. 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)
  5. 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)
  6. Implement support for Raspberry Pi and arm general Iot using lazarus. Im a lazarus user and rapsberry work exceleent with my app. Just need a stable dataaccess like unidac on raspberry pi.

    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. 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  ·  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. How to save TUniQuery to TVirtualQuery quickly ?

    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)
  9. I would like to develop server program at LINUX(Lazarus) and client program at Windows(Delphi). I need to pack dataset on server site. I am using unidac with sql to access relational database. It is better to save returned dataset to memorystream quickly and transfer the stream to client. Also I want to restore memorystream to uniquery dataset quickly.

    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)
  10. When working with DevExpress VCL Tools the Append and Insert are different, and no im forced to use Insert instead of Append in the CX grid because the append have no corresponding event in Unidac, i cant catch it. The insert and append behaves different in the CX grid.

    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)
  11. Please add the function dayoftheyear to the list of unified sql functions

    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)
  12. You guys use several uncommon directories for 3rd party components : 1: windows\System32 for some BPL
    2: Delphi\Lib for some dcp
    3: Delphi\Bin for some other BPL
    4: UniDAC for dcu

    How about using
    BDSCommon\BPL for all bpl
    BDSCommon\DCP for all dcp
    leaving the dcu in the lib of the unidac install directory

    To explain : As a developer i work with several virtual PCs that I have to update. I use a local SVN for that. Installing unidac is always a hassle because after the install I first have to copy everything where it's supposed to be and then…

    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. Add monitoring feature to uniDac to let developers monitor each events occured to MySQL database (insert, update, delete..) and return the result.

    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)
  14. CRDBGrid have only one popup where it shows "Filtered", "Filter Bar", "Search Bar" as a text and everything else is pictures on it. Or, field names which can be set by programmer.

    It would be nice to be able to localize these texts in the object inspector. Should be pretty easy to implement, and would be a nice addition to the component.

    0 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)
  15. sometimes user adding in access mdb, accdb query a vba function , so i hope that could the access query using vba function executed also on delphi

    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)
  16. DB table has column varchar(200), in application i want to restrict field size to 50 characters.
    In ADO Components TStringField.size restrict string column size, but UniDAC, after open table, discard my TStringField.Size and set it to column size, that column has in DB.

    70 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. Timeout for connection pooling is fixed for 30000 ms in Unidac ( It is a local constant variable). It is not enough for some applications. We need more control on connection pooiling. It would be better if developer could set timeout as a property.

    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)
  18. For now, if some of the data I need to load in db I'm not able to calculate all fiellds values, there's no way to indicate TUniLoader to let the DB Server apply the fields "DEFAULT VALUE" constraint if any.
    A good way could be to make TUniLoader able to see no value (nor Null) was given to a column (so, still in "Unassigned" state).

    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  ·  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)
  19. As JSON more popular。
    It's time to support JSON in uniquery.

    43 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  ·  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)
  20. Add a "comment" property to possible UniDAC components. It could be very helpfull to add comments to TUniConnection, TUniQuery, TUniTable, ... because technical names are often short or meaningless and a comment can translate it into a meaningful description.

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