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. 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)
  2. 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)
  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. 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)
  5. 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)
  6. Unidump should backup and restore virtual/ stored virtual fields

    7 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)
  7. TUniAlerter.OnEvent is always called in the main application thread regardless in what thread TUniAlerters is created or used.
    Devart advice is to use a synchronize, but that is not always possible or wanted. Why or you otherwise using threads?

    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)
  8. 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)
  9. Scenario: 100K customer (master rows) with an average of 10 contact (detail) rows each... totaling about 1M detail rows.

    Without CachedUpdates I set LocalMasterDetail to false, and each time I scroll on the master dataset UniDAC fetches the 10 or so detail rows from the database. I can insert, modify and delete rows and all is saved immediately (on Delete or Post).

    With CachedUpdates I have to set LocalMasterDetail to true. This means UniDAC will fetch 1M detail rows and filter them out locally. With large networked databases this is really not feasible as it generates too much network traffic…

    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)
  10. Perhaps it's an idea to have an indicator on each specific post to show whether a topic has been answered?
    This could be as simple as a check box indicating the post has been answered - filled in by the original requester when the requester is happy with the response(s).
    Once the tick box is completed the post could be flagged with an icon - e.g. a green tick mark - and thus considered 'closed'.
    Would help responders to skip those posts already answered and those wishing to find answers to skip those posts that have not yet been answered.…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  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)
  11. 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)
  12. When you have a query like

    select *
    from mytable
    where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodTo

    Then the params property of a TMSQuery component now contains the parameter 'PeriodTo' twice. This behaviour differs from the behaviour of TUniQuery. I think the behaviour of TMSQuery needs to be changed such that is has the behaviour of TUniQuery.

    2 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)
  13. 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)
  14. 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)
  15. Today i'm more and more using TClientDataset because of the cloned cursor and Unidac just for for synchronize and transport between the back end database and the TClientDataset. With a cloned cursor multiple components can share the same data-space and the speed and memory gains are huge, but i would preferer to do this in the unidac and not have another extra layer of technology.

    A tQuery with all the functionality of tClientDataSet would be very nice and Firedac is moving that way.

    15 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  ·  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)
  16. When TMSConnection.Authentication is auWindows the username is the currently logged in user, it woudl be good to have a way to connect as another user. There could be a new property TMSConnection.ImpersonateUser, if this is set and auWindows is set the connection will be done as if that user is logged in.

    2 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. if you apply two different transaction in TIBCQuery.Transaction and TIBCQuery.UpdateTransaction property, then dbMonitor will show update/insert/delete statements in TIBCQuery.Transaction branch.

    Actually it should be shown in TIBCQuery.UpdateTransaction branch

    RUS
    Если вы применяете две различных транзакции в свойствах TBCQuery.Transaction и TIBCQuery.UpdateTransaction то dbMonitor показывает выражения update/insert/delete в ветке транзакции TBCQuery.Transaction.
    Однако хотелось бы видеть в ветке TIBCQuery.UpdateTransaction

    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)
  18. Add Events in TCRBatchmove to react if an error occurs.

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