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. When using TADOConnection / TADOQuery to create datasource for TDBGrid, columns from main tables as well as joined tables may be edited in the grid. With TUNIxxx components, only the first table in the query can have its columns updated in the 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)
  2. Many people do not bother with the beginning and ending a transaction, however, is of paramount importance to know when a good design to start and control your transactions.

    Thus, it would be very interesting to have an option to control when the user wants to leave the components create or open a new transaction and when the user want and need to manually create your transactions.

    So, a option to let the user control the creation and maintenance of TRANSACTIONS manually, not automatic as with the current version (v5.5.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  ·  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. Create a more efficient system and connected to the Delphi IDE help. It seems that the team is out of date regarding the use of the Delphi help system, and, so far, not integrated their help file to the standard used by professional components for RAD Studio.

    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)
  4. String parameters sometimes have special formatting forms, and it will be very useful to have a TMemo control to save a reminder on how the parameter should be formatted.

    I mostly make use of String parameters to the TO_DATE function instead of DateTime parameters to avoid any conversion issue due to local Date and Time configuration.

    It will be necessary to add a String property (Comment) to the TOraParam class to hold the comment data and add a TMemo control to the Parameters tab of the ODAC components (TOraQuery, TSmartQuery, TOraStoredProc and TOraSQL ) Editor.

    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  ·  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)
  5. Возможность выполнять запросы в локальном кеше при установке
    значения IBCQuery->LocalUpdate=true

    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)
  6. Sometimes results is to big to be save or more often to be loaded into a tVirtualTable (not enough memory). Solution should be to split the result files into several smaller ones (according to line numbers or size).

    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)
  7. At execproc runtime call when this option is checked and the value of the parameter is null display a warning message.

    When "mandatory" is not checked nothing is done and the component workd like before.

    The principe is a bit like "assertions" in code ... we want to make sure that parameters required by procedures are filled by programmers and not forgotten.

    Thanks
    Those who don't want the feature can just ignore it.

    The concept could be extended to an assertion formula, but for us a checkbox is enought

    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  ·  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. improve you web side by putting away the left side bar of facebook

    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)
  9. 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)
  10. 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)
  11. 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)
  12. Have the TCRGrid component display with the currently selected theme style

    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  ·  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)
  13. Simply add #ifndef SQLITE3H_ in e.g. LiteCall.hpp.

    The location is around line 460:
    //-- var, const, procedure ---------------------------------------------------

    define DACProductName L"LiteDAC"

    define SQLiteDLLName L"sqlite3.dll"

    ifndef SQLITE3H_

    static const System::Int8 SQLITEOK = System::Int8(0x0);
    static const System::Int8 SQLITE
    ERROR = System::Int8(0x1);

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