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
  1. 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

    335 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  12 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  2. Шифрование входных и выходных параметров хранимых процедур.
    В 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.

    225 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. 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.

    193 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. 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. Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
    This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.

    111 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 →

    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. TConnection/TQuery 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.


    108 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. 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 →
  7. Implement COPY FROM/TO functionality for PostgreSQL (PgDAC component).

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

    101 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 →
  8. 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 →
  9. 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.

    82 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 →
  10. Uniquery sql editor editopr should be improved, showing Tables, fields and stored procedures with drag and drop (Fibplus like).

    78 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 →
  11. 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 →
  12. create table method which is database independend.

    70 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 →
  13. 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

    69 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 →
  14. 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)

    65 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 →
  15. 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.

    61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  UniDAC  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    59 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. Fast Report in Lazarus frxODACComponents is not included in the set of our componente when using the Lazarus environment

    58 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Oracle  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    54 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 →
  19. 50 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 →
← Previous 1 3 4 5 11 12
  • Don't see your idea?