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. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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)
  7. 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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  13. 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)
  14. 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)
  15. 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)
  16. Add support Transaction Guard (Oracle 12c New Feature) in ODAC

    8 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)
  17. Backup procedure takes lot of time.
    And user have no visual response. In large databases it takes minutes.
    Why there is no OnProgress event to visually show estimated time with progress bar ?

    8 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. Quite simple, just add another button and menu item to clear all terminated processes, rather than just repeatedly clicking the current button.

    9 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  ·  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. Manually parse SQL for MBCS strings.
    Latest UniDac MBCS specification is not full compatible with BDE/DBX(Delphi Ansi version).
    and issue parse exception by mistake and macro function character at not ParamCheck.
    and this exception is difficult to understand the cause.
    (I have send details to support already)

    Please add the following property/Event.

    1. SkipParseSQL property
    2. OnBeforeParseSQL
    3. OnSQLParseError
    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)
  20. There is no Delphi solution for accessing MySQL database optimized for performance on heavy loaded servers.

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