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. user manual for beginners who exemplefique simplified models to use advanced functions.

    The help system is very simplified and UNIDAC says very little for those who are migrating to SQL universe.

    Do you use one language for those who already have a much better knowledge of advanced programming examples in its accompanying suite

    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)
  2. TMyTable.IndexDefs property contains information about the indexes of a table, however, there is no way to use any of these indexes.

    See thread in forum SQL Index file in Data Access Components for MySQL

    2 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)
  3. Happy New Year to everyone !

    I'm wondering if you can implement one new thing in your components...

    TIBCDataSource put by a TIBCQuery makes automatically connection to this TIBCQuery. Could you extend this procedure by adding code that would name TIBCDataSource not standard IBCDataSource1 but eg. ds_ + name of Query component.

    Example
    I have IBCQuery component named qcompanies. New TIBCDataSource should be named dsqcompanies instead of IBCDataSource1.
    If you are smart enough, you could recognize, that "q
    " a prefix of query component and name DataSource as ds_companies.

    It concern every your DAC component set.

    It…

    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. Currently it is not possible to use UniDAC to compact an existing Jet database.

    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  ·  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. 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)
  6. For Firebird the possible value for RowsPerBatch depends on the number of rows in the table because the maximal length of an SQL statement is 64KB.
    For RowsPerBatch=0, UniDac should calculate the maximal possible value itself.

    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  ·  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. 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. 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)
  9. 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)
  10. When you have a query like

    select *
    from mytable
    where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodTo

    Then the params property of a TMSQuery component now contains the parameter 'PeriodTo' twice. This behaviour differs from the behaviour of TUniQuery. I think the behaviour of TMSQuery needs to be changed such that is has the behaviour of TUniQuery.

    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. Additional buttons:
    - refresh record;
    - QBE mode on/off;
    - run QBE.

    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  ·  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)
  12. WHen DatasetManager is used to drop field to form, title of type TLabel is generated. No chance to change it. Will be nice to have same chance use other type, for example TcxLabel (DevExpress suite).

    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)
  13. 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)
  14. ADD new function to export the XML from your table
    components in a format compliant with the XSD schema
    instead of the XDR format you're using now

    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  ·  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. inidac page claims multiple transaction supports. IBDAC is rumored to be slcie of UniDAc but it does not claim overlapped and evenmere nested transactions support at http://www.devart.com/ibdac/features.html

    I think that should be stated clearly whether this feature been removed from IBDAC or stays there.

    1 vote
    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)
  16. I'm cobnverting from ADO to MyDac...and the tables don't have a SORT function.

    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  ·  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 would like complete control on how the parenthesis are added to the where clause. The way they are added now, it can result in a where clause that won't return what you're looking for.

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