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. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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)
  7. 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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  13. 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)
  14. 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)
  15. 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)
  16. 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)
  17. 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)
  18. 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)
  19. DB table has column varchar(200), in application i want to restrict field size to 50 characters.
    In ADO Components TStringField.size restrict string column size, but UniDAC, after open table, discard my TStringField.Size and set it to column size, that column has in DB.

    70 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  ·  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. Timeout for connection pooling is fixed for 30000 ms in Unidac ( It is a local constant variable). It is not enough for some applications. We need more control on connection pooiling. It would be better if developer could set timeout as a property.

    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  ·  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?