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. Procedure TCustomMSConnection.OpenDatasets doesn't work with Direct mode (MSConnection.Options.Provider := prDirect) but works with ODBC or SQL Native Client provider. I suggest implementing it in Direct mode.

    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)
  2. When you need to debug some SQL, you can save the SQL query to a file and then run it outside of your application to check for any issues with the query. However, you cannot do the same when using parameters. When you try to save SQL.Text to a file, you will get the query with parameter names, such as SELECT * FROM A WHERE Id = :paramname. To debug effectively, I need to see the values of the parameters. Ideally, I want to save the query with the actual parameter values, like SELECT * FROM A WHERE ID =…

    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  ·  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)
  3. DuckDB is an open source free and very good embedded database, is it possible to fully embed DuckDB into delphi programs like SQLite, without external DLL files?

    https://duckdb.org/
    https://github.com/duckdb

    12 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. Connect to Firebird direct via Android and IOs without the need for a DB Client similar to PostgreSQL, Mysql, Redshift and Nexus.

    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. You can order your query/table with the property IndexFieldNames. But if you have an varchar field that contains numbers, the order is wrong. You get:

    1
    11
    2

    But better would be:
    1
    2
    11

    This can be done with the "natural sort" algorithm. Please implement it for the use with IndexFieldNames like:

    ATable.IndexFieldNames := 'MyField natural';

    I know I could sort it with SQL, but I need client side sorting with the property IndexFieldNames.

    For natural sort see:
    https://en.wikipedia.org/wiki/Natural_sort_order

    (As far I know Windows uses StrCmpLogicalW to sort file names in that way)

    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)
  6. In Postgres it's possible to create an readonly column,

    See
    https://www.postgresql.org/docs/current/sql-createtable.html

    GENERATED ALWAYS AS ( generation_expr ) STORED
    This clause creates the column as a generated column. The column cannot be written to, and when read the result of the specified expression will be returned.

    Automatic generated SQL for INSERT OR UPDATE don't handle the column as readonly. If you set UpdateAllFields to true an exception is raised. Also an exception occurs when you change the value of this field an call Post.

    The column should be set to readonly an the corresponding field should be excluded from INSERT andUPDATE.

    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  ·  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)
  7. Looking in the "UniDAC\Demos\ThirdParty\FastReport\" folder, I found a component: "TfrxUniDACComponents", which integrates Unidac with FastReport for Delphi, but I didn't find it for Lazarus. I'm using Lazarus 2.2.6 and would like to know if it's possible to develop this component for Lazarus as well.

    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)
  8. For remote server with REST we need a FAST Json result from Db driver, direct, avoiding dataset marshalling.

    3 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)
  9. I would like it to have a record limit setting that is the same or similar to what exists in FireDAC.
    This configuration and the behavior of FireDAC with this configuration would be nice to have in the Devart ODAC component.

    Here is an example of what exists in FireDAC:
    TFDQuery.FetchOptions.RecsMax := 100;

    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  ·  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)
  10. Currently we are migrating Oracle to PostgreSQL DBExpress. With Oracle, we were able to categorize DBExpress errors based on the message "ORA-XXXXX" and perform appropriate error handling. We had to do this because of the limitation of DBExpress.

    With PostgreSQL, we have the problem that we only get the error message. So we would have to parse all error messages individually. Per error code there are 1:n different PostgreSQL error messages!

    Therefore our question to you: Would it be possible to set the error code analog to Oracle at the start of the error message?

    For example "PG-22023 input string…

    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  ·  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)
  11. 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. When using batchUpdate, we have a total RowsAffected, but cannot know how many rows were affected by each individual parameter array item.
    So if you take different actions according to return value of RowsAffected, batchUpdates cannot be used.
    It would be nice to have a RowsAffectedArray (DynamicArray<__int64>, size = params.ValueCount) holding this value.

    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. Unlike other product such as ODAC, for virtualDAC, as now I am using VirutalQuery, if debug is set to true, it seems that dialog will be shown at each step, which make the debug in thread/service very difficult.

    Is it possible, like TOraMonitor of ODAC, we have have sort of TVirtualDACMonitor for VirtualDAC, to push the debug information to dbmonitor, the same behavior as of other product family?

    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)
  14. Unlike other product such as ODAC, for virtualDAC, as now I am using VirutalQuery, if debug is set to true, it seems that dialog will be shown at each step, which make the debug in thread/service very difficult.

    Is it possible, like TOraMonitor of ODAC, we have have sort of TVirtualDACMonitor for VirtualDAC, to push the debug information to dbmonitor, the same behavior as of other product family?

    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. For debugging purposes we often add
    raise notice '%', some_variable
    which is handy because can give us back information without stopping the app like 'warning' or 'exception' would.

    It would be great if DBmonitor could catch such notice and show somehow.

    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)
  16. With PostGreSQL it is possible to specify multiple host components, each with an optional port component, in a single URI. A URI of the form

     postgresql://host1:port1,host2:port2,host3:port3/ 
    

    is equivalent to a connection string of the form

     host=host1,host2,host3 port=port1,port2,port3. 
    

    Each host will be tried in turn until a connection is successfully established.

    I'd like UniDAC to support this approach.

    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)
  17. I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded/refreshed already.
    Can you please add here any function, which can check it ?

    3 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)
  18. Uniquery,VirtualTable, etc..
    add new functions
    SaveToJSON
    SaveToCSV

    For TVirtualTable
    Add new functions
    LoadFromJSON
    LoadFromCSV

    So the weight of transfered data would be much LOWER then transfer an XML file...

    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  ·  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. Uniquery,VirtualTable, etc..
    add new functions
    SaveToJSON
    SaveToCSV

    For TVirtualTable
    Add new functions
    LoadFromJSON
    LoadFromCSV

    So the weight of transfered data would be much LOWER then transfer an XML file...

    23 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. The possibility to read/write Geometry-Data-Types of PostGIS (MultiPolygon, Collections etc.) as it is possible with PostGreSQL-Geometry-Data-Types like lseg, polygon etc.

    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  ·  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)
← Previous 1 3 4 5 12 13
  • Don't see your idea?