243 results found
-
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/GetOptionalParam347 votes -
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.
225 votes -
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.201 votes -
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
upWhereKeyOnlyImplementing this property in TIBCQuery
solve my problem of concurrency.thanks
132 votes -
TIBCTransaction.OnEnd
Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.111 votes -
Improve data type mapping feature
Allow set field type mapping / rules by CHARSET
Ex: if db field charset is UTF8 set field as TWideStringFieldset field type mapping / rules by DOMAIN
Ex: if db field domain is DM_BOOLEAN set field as TBooleanField[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 votesThe first and the second features have been implemented.
-
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…
103 votes -
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.html103 votes -
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 -
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.
82 votes -
Better sql editor in Unidac
Uniquery sql editor editopr should be improved, showing Tables, fields and stored procedures with drag and drop (Fibplus like).
79 votes -
Create table in unidac
create table method which is database independend.
70 votes -
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 -
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)
69 votes -
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
69 votes -
68 votes
-
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.
63 votes -
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.
59 votes -
Lazarus frxODACComponents
Fast Report in Lazarus frxODACComponents is not included in the set of our componente when using the Lazarus environment
58 votes -
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.
57 votes
- Don't see your idea?