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

246 results found

  1. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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)
  7. 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)
  8. Firebird over Internet is very slow, Firebird 3 solve this problem useing compress,please Implement Dbexpress Driver to support Firebird 3 compression

    about firebird 3 compress :
    http://www.firebirdnews.org/firebird-3-protocol-benchmark/

    15 votes
    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)
  9. Support for the TDataset.FieldOptions property in IBDAC, specialy the AutoCreateMode so the TIBCQuery can add missing TFields automaticlly

    19 votes
    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)
  10. The TMSTableData Component Assign function only copy the source table fields, but not copy the source data! I strongly recommend that can copy the all data like the TMSTable component.
    for example:
    self.MSTable1.First;
    self.MSTableData1.Close;
    self.MSTableData1.FieldDefs.Clear();
    self.MSTableData1.Assign(self.MSTable1);
    self.MSTableData1.Active:= true;

    The MSTableData1 not copy the MSTable1 data , but it copy the fields

    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)
  11. An optimized version of this (maybe without the need to go to/from dataset to make it go faster)

    var
    query: TMSQuery;
    VirtualTable: TVirtualTable;
    begin
    query := db.CreateMSQuery( ); //returns TMSQuery
    query.SQL.Text := 'select * from [table]';
    query.open;
    result := binary.create;
    VirtualTable := TVirtualTable.Create(nil);
    VirtualTable.Assign(query);
    VirtualTable.saveToStream( result );
    VirtualTable.free;
    query.free;
    end;

    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  ·  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)
  12. Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.

    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  ·  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)
  13. 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)
  14. 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)
  15. Passing parameters by name is more reliable than by index, aspecially when stored procedures is not constant and parameter's list is changed frequently.

    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  ·  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)
  16. ODAC has always allowed clearing IndexFieldNames without reverting to the original sort order. The ability to sort a dataset and then turn off active sorting is very useful (and necessary for editing a sorted dataset in a grid component.)

    24 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  ·  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)
  17. support distributed transactions in MYDAC

    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  ·  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)
  18. Add support for unsigned int64 in SQL-parameters. Using uInt64 is currently troublesome, as this needs to be done via IntToStr or other tricks.

    This makes the code harder to write and also clutters the list of param's - having some of them are dome directly in the SQL-text and having other's in the param-list.

    For me (and many other, I guess), the use of unsigned uInt64's gets more and more widespread, eg. in IP-numbers as INETATON/INETNTOA in big data.

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