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

How can we improve our Delphi Data Access Components?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Using TVirtualTable replace with TClientDataSet

    1.supports Aggregates
    2.supports Data And Delta!
    3.supports binary formatter data,like TClientDataSet!
    4.supports json data!
    5.supports SQL Memory.
    6.exports updated SQL!
    7.Supports Merge Delta Data,Reconcile Delta Data!
    8.Every record have Single row number,it can use to locate record!
    9.Supports DataSetField!
    10.Supports SetOptionalParam/GetOptionalParam

    323 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  11 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  2. Encryption of the input and output parameters of stored procedures

    Шифрование входных и выходных параметров хранимых процедур.
    В IBDac есть возможность шифровать\расшифровывать на клиенте данные. Только с хранимыми процедурами это не работает.

    Encryption of input and output parameters of stored procedures. There is a capability in IBDAC to encrypt/decrypt data on the client. But it doesn't work with stored procedures.

    224 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support Dev Express Grid Server mode

    Dev express have implemented a new server mode
    http://www.devexpress.com/Subscriptions/VCL/WhatsNewBuild12.1.3/index.xml?page=2#autolist1
    But it works only on ADO and DBexpress, perahaps you can work together to support unidac.

    183 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Implementing UpdateOptions - TIBCQuery

    Two users modify the same field in the table,
    Error want to show the second user to save data.

    -) Using a TClientDataser and TDatasetProvider, no problem, works well.

    -) TFDQuery component FireDAC the Embarcadero it has the property
    Property: UpdateOpcions
    UpdateMode:
    upWhereAll
    upWhereChanged
    upWhereKeyOnly

    Implementing this property in TIBCQuery
    solve my problem of concurrency.

    thanks

    129 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  5. TIBCTransaction.OnEnd

    Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
    This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.

    109 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  6. Improve data type mapping feature

    1. Allow set field type mapping / rules by CHARSET
    Ex: if db field charset is UTF8 set field as TWideStringField

    2. set field type mapping / rules by DOMAIN
    Ex: if db field domain is DM_BOOLEAN set field as TBooleanField

    3. [Optional] Separate TFieldMappings component that allow to define custom field mappings. T*Connection/T*Query should have a property of this type.
    Useful when use multiple connections (for example in threads), to define mapping rules once and link all Connections to one common component.

    106 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  7. TIBCQuery.OnScrollFinish

    Implement OnScrollFinish event that is fired at the end of the scrolling process.

    For example we need to adjust some elements of interface on record change, even perform an aditional sql query or other heavy calculations.

    For example, if user scroll fast over 20 records in a grid, relying on AfterScroll event imply a lot of unused work. So instead executing it 20 times, we may do this once after scroll process is finished.

    In fact, such kind of logic in *Dac already have it on Master/Detail "wait" magic, so it's not too much to change to have this kind…

    102 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  8. Implement COPY FROM/TO functionality

    Implement COPY FROM/TO functionality for PostgreSQL (PgDAC component).

    PostgreSQL COPY manual:
    http://www.postgresql.org/docs/current/interactive/sql-copy.html

    95 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  PostgreSQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add a limit for the record count in the DataSet

    Add a parameter, for example, MaxFetchRows, which will limit the number of records which can be fetched to the DataSet.

    83 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  5 comments  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
  10. Save settings to the database as in an *.ini file or in registry

    Many applications use TiniFile or TRegistry for saving their settings. However sometimes one user can work on several workstations with his login and password. He wants to have the same settings on all of his workplaces, and that settings, saved on one computer, were available on other ones.

    To implement this feature we may add classes or components with interface similar to TiniFile or TRegistry that save data not on the local computer, but in a database.

    79 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
  11. Better sql editor in Unidac

    Uniquery sql editor editopr should be improved, showing Tables, fields and stored procedures with drag and drop (Fibplus like).

    76 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  12. Implement TStringField.Size restriction

    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
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  13. Create table in unidac

    create table method which is database independend.

    66 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  14. Add properties KeepAlive + KeepAliveInterval (maintain the connection)

    The component should TUniConnection every 3000 ms (for example) to send to the server any single request (for example, "select 1 from dual"), to the gateway and the server is "seen" that the connection is active and the client is connected.

    RUS:
    Компонента TUniConnection должна, каждые 3000 мс (к примеру) отправлять на сервер какой-нибудь холостой запрос (к примеру, "select 1 from dual"), чтобы шлюз и сервер "видел", что соединение активно и клиент подключен.

    Сообщение на форуме: http://www.devart.com/ru/forums/viewtopic.php?p=2081#2081

    63 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
  15. Direct connection to 3050 Firebird port for IBDAC

    IBDAC should be able to connect directly to Firebird servers talking directly to port 3050 like ODAC does for Oracle. This would allow us to run our apps without installing Firebird client dll. It would also allow us to connect to Firebird Servers from iPads, iPods etc. (especially now that XE4 is out)

    53 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
  16. Creating a provider for ADO

    ADO access is included in some form in the SQLServer provider. Possibly it could extended to support other Ado providers/drivers. For example foxpro has ado driver till version 9, the odbc driver is at version 6. MSAccess is another example.

    53 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  17. Adding the OnInfoMessage event for UniConnection

    Some of our DAC products support receiving information messages from database servers. (ToraSession and TMSConnection have the OnInfoMessage event, PgConnection has OnNotification event). We may add such event to TuniConnection; it will be called when a message from a database server is received.

    51 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  18. Can you add the feature to UniDump so that it can backup *all* database objects? In MySQL currently

    Can you add the feature to TUniDump so that it can backup *all* database objects? In MySQL currently it only does tables and views. I would like to backup stored procedures and functions also. I haven't tried other databases (Firebird, Postgres etc) but this would be a great feature to be able to to backup / restore the entire database.

    50 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  19. Forced sending queries to the server without parameters

    Queries may be with or without parameters:

    select *
    from test_table
    where id = :ID

    or

    select *
    from test_table

    However some database servers execute queries without parameters faster than the same queries with parameters. An option (for example, AllowParams) may be added; if this option is set to False, all queries will be sent to a server as text.

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Common  ·  Flag idea as inappropriate…  ·  Admin →
  20. Over-the-Wire (OTW) encryption for InterBase 2009

    Add support for Over-the-Wire (OTW) encryption for InterBase 2009

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  InterBase/Firebird  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 9 10
  • Don't see your idea?

Delphi Data Access Components

Feedback and Knowledge Base