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

44 results found

  1. 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  ·  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)
  2. Support for InternalCalc fields. This is really usefull feature. And is supported by FireDac and ClientDataset.

    5 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)
  3. To control the implicit transaction

    4 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  ·  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. I think, the memoryTables are most usefull as secondary tables whith data saved in master tables as BLOBs.
    In this case, is big advantage to be saved compressed.
    Maybe this behavior is better to be default as it saves space and time.

    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  ·  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. 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)
  6. 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)
  7. 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)
  8. It looks that there is no universal solution to notify about moment when TOraSQL / TCustomDADataSet class (and its descendants) finishes fetching all data in NonBlocking mode.

    There should be added some event that related to Fetched method

    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)
  9. Multiple dataset result in Unidac. In SDAC it is possible to have multiple dataset as a result of executing a query. With CanOpenNext it is possible to open the next dataset. MySql has the same capabilities. We would appreciate to have this functionality the same way Sql Server componentset has 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…)
    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. With all the different DAC products, I don't have space in my IDE for all the pull down menus. Especially since I have RemObjects, GExpers, MMX, etc, etc. It would be more optimal to have one single DevArt pull down menu in the IDE and then have a submenu for each DAC product.

    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)
  11. It would be great if I can simply right click on a table component (TIBCQuery in case of IBDac) and choose a command to display list of fields and select some of them or all then after press on ok all these fields added to the debugger watches window in format of <module>.<table>.FieldByName('Field_Name').As<Proper Data Type>

    This way I can quickly add watches for many fields from as many tables as I want at a single click and debug become more easier and faster

    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)
  12. 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)
  13. 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)
  14. Happy New Year to everyone !

    I'm wondering if you can implement one new thing in your components...

    TIBCDataSource put by a TIBCQuery makes automatically connection to this TIBCQuery. Could you extend this procedure by adding code that would name TIBCDataSource not standard IBCDataSource1 but eg. ds_ + name of Query component.

    Example
    I have IBCQuery component named qcompanies. New TIBCDataSource should be named dsqcompanies instead of IBCDataSource1.
    If you are smart enough, you could recognize, that "q
    " a prefix of query component and name DataSource as ds_companies.

    It concern every your DAC component set.

    It…

    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)
  15. user manual for beginners who exemplefique simplified models to use advanced functions.

    The help system is very simplified and UNIDAC says very little for those who are migrating to SQL universe.

    Do you use one language for those who already have a much better knowledge of advanced programming examples in its accompanying suite

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