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. FIBPlus have a great and simple way to quickly ask databse about value or set of values, this method is called QueryValue. If I want to ask database for only one row, I do not want to create a dataset for it. It causes a big overhead.

    Instead I would like to ask for a value like this:

    MyValue := Connection.QueryValue('SELECT TOP 1 USERNAME FROM USERS WHERE SURNAME = :SURNAME', [Surname])

    5 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)
  2. Currently TIBCLoader allows only to Load data by handling particular events. If I want to save something to database I need to handle OnPutData event. Unfortunately this solution requires usage of global variables because to know what I want to insert I need to look for some data beyond the scope of an event.

    Even the simple demo of yours shows this problem. You are using a global variable Count to know how much data you want to put it. Rest of the data you are using in a demo is random so it could be generated locally in the…

    4 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)
  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. 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)
  5. 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)
  6. Trivial: SQLite: when user dblclicks TLiteDump it does not open string list editor like in TMyDump

    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  ·  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. Add new property FlatADTView (default false for not changing standard behavior of TOraQuery) for showing fields separately in ftADT field in Object View mode.
    Example:
    CODE: SELECT ALL
    create or replace type ComplexType as object(
    x varchar2(100),
    y varchar2(100)
    );

    /

    OraQuery1.SQL.Text := 'select ComplexType(CODE, name) A from TEST';
    OraQuery1.ObjectView := True;
    OraQuery1.FlatADTView := True; (new property)
    OraQuery1.Open;

    And I want to see:
    CODE: SELECT ALL
    A.X | A.Y
    1 | 2
    3 | 4
    like OraQuery1.ObjectView := False but this variant friendly for collections datatype.

    25 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  ·  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. the TUniMetaData data-type field now returns different data for different databases - Example:
    currently for MySql it returns a string e.g. 'float'
    but for MS SQL server it returns a number: e.g. 5 (for float fields)

    so the recommended improvement is to add a new field to the result that returns a string representing the native database type.

    this feature is useful if you want to show a list of columns including data-types to the user - it can also be used to generate a create script, etc.

    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)
  9. dbMonitor, which is a great feature, shows any string values as <BLOB:19> instead of the actual data in that field. This might only apply to postgresql

    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)
  10. When converting from Paradox to SQLite, I ran into 2 problems.
    1) the TableName.DB I used in paradox does NOT have a .DB ending in the actual tablename...
    2) The data module where the "database1" was declared for the TUniConnection was not included in the files, and then the connections were not set to them. I had to open all the forms and remove the .db and set them

    I think that the Migration Wizard should handle those better...

    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. Put some simple sample code into the help/demos files, that must be great. some times that be very usefully

    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)
  12. Please update the help file, and try to be more explicit on the definitions

    7 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)
  13. It will not take over the identical field names of a view. If multiple fields have the same name located in different sub-tables of this view.

    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. Please include the scheme name of the stored procedure because now you have to include it manually, and if you dont it throws an error can find stored procedure, if i run MyStoredProcedure it throws an error but if i change it to MyScheme.MyStoredProcedure manually it works.

    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)
  15. There are some great uses for graph databases and the Delphi desktop world would benefit greatly

    17 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)
  16. Hello, I would appreciate (for easy migration from FIB+ to your component suite) adding OnFieldChange event and the CloneCurrentRecord.

    13 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)
  17. 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)
  18. Create means to eliminate overhead at the compiler or configuration level. Compiler would be better because it would have 0 overhead in the resulting app; whereas config would have to check if the area was desired.

    The use case for me is that I have an app, 100% non-visual. It runs as a batch job. This app could/should be able to run faster if it didn't bother doing things that a non-visual app doesnt care about. ie - master/detail.

    Most libraries I have seen have a configurable .INC which control what the behavior is at compile time. This would be…

    2 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)
  19. Entity developer would be a great addition to Rad Studio for use with PGDac. Either with code generation, or just as a DB design tool.

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