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

243 results found

  1. The RefreshQuick method (https://www.devart.com/mydac/docs/devart.mydac.tcustommydataset.refreshquick(system.boolean).htm) seems very useful to refresh only the new records from big datasets. Ideally, make it possible to specify the name of the TIMESTAMP field so we don't have to create a duplicate - mine are called "created" for example). Maybe we don't even need the TimeStamp field for Postgresql ?

    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  ·  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)
  2. When I create a SqlMonitor but with Active := False the component or unit is sending a string to the monitor to say, that it has started, although it's inactive.
    Now imagine that with some 50 or 100 clients and you want to check the SQL of 1 certain workstation.

    Couldn't that be turned off ?

    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)
  3. It would be helpful in the SQL Monitor to execute the query I'm seeing to see the result set my app receives.
    Sometimes I have to check something where the client is and I place the sql monitor to see, what SQL my app is sending and have to enter with a db explorer to check the sql with the parameters sent, what the result is. It would be cool, if the dbmon could have that built in, because the dbmon already has the sql and the params right there.

    This would often make my work much easier

    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)
  4. hi,
    Devexpress servermode nearly 10 times faster than unidac native components.
    Is there any chance you can also implement servermode into unidac?
    thank you

    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  ·  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. 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)
  6. 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)
  7. Я знаю, что у 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)
  8. У компонентов 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  13. 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. When you add a new sql function at runtime (TLiteUtils.RegisterFunction) you can't use it at design time in a UniQuery because the function is unknown.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. It's about time dbMonitor had a long awaited upgrade with some really basic common sense pieces of functionality added.

    1) Add buttons to clear terminated processes and all processes. Come on guys, having to select each process one by one to clear it is, quite frankly, ridiculous and poor UI design.

    2) Parameters should be formatted according to the DB you're connected to.
    E.g. for Oracle
    Like this...
    :SrcSchema VARCHAR2(13) :='MY_SCHEMA' ;

    rather than this

    :SrcSchema(VARCHAR[13])='MY_SCHEMA'
    Why? Well it allows us developers to set up anonymous blocks quickly to test the same call, if say an error occurs. Currently I…

    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)
  17. db Monitor has fetch checkbox that is useless at the moment.
    It would be nice if the fetch time would be sent to the db monitor

    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)
  18. For debugging purposes we often add
    raise notice '%', some_variable
    which is handy because can give us back information without stopping the app like 'warning' or 'exception' would.

    It would be great if DBmonitor could catch such notice and show somehow.

    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)
  19. Unlike other product such as ODAC, for virtualDAC, as now I am using VirutalQuery, if debug is set to true, it seems that dialog will be shown at each step, which make the debug in thread/service very difficult.

    Is it possible, like TOraMonitor of ODAC, we have have sort of TVirtualDACMonitor for VirtualDAC, to push the debug information to dbmonitor, the same behavior as of other product family?

    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)
  20. Unlike other product such as ODAC, for virtualDAC, as now I am using VirutalQuery, if debug is set to true, it seems that dialog will be shown at each step, which make the debug in thread/service very difficult.

    Is it possible, like TOraMonitor of ODAC, we have have sort of TVirtualDACMonitor for VirtualDAC, to push the debug information to dbmonitor, the same behavior as of other product family?

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