246 results found
-
Cloned Cursors
Today i'm more and more using TClientDataset because of the cloned cursor and Unidac just for for synchronize and transport between the back end database and the TClientDataset. With a cloned cursor multiple components can share the same data-space and the speed and memory gains are huge, but i would preferer to do this in the unidac and not have another extra layer of technology.
A tQuery with all the functionality of tClientDataSet would be very nice and Firedac is moving that way.
15 votes -
Support for the TDataset.FieldOptions property in IBDAC
Support for the TDataset.FieldOptions property in IBDAC, specialy the AutoCreateMode so the TIBCQuery can add missing TFields automaticlly
19 votes -
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 votes -
Support Postgres Advanced Server
Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.
6 votes -
TMSQuery.SaveToStream/LoadFromStream the entire data set
An optimized version of this (maybe without the need to go to/from dataset to make it go faster)
var
query: TMSQuery;
VirtualTable: TVirtualTable;
begin
query := db.CreateMSQuery( ); //returns TMSQuery
query.SQL.Text := 'select * from [table]';
query.open;
result := binary.create;
VirtualTable := TVirtualTable.Create(nil);
VirtualTable.Assign(query);
VirtualTable.saveToStream( result );
VirtualTable.free;
query.free;
end;4 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 -
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 -
TIBCTransaction.OnEnd
Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.111 votes -
Add savetoJSON to uniquery
As JSON more popular。
It's time to support JSON in uniquery.43 votes -
Spatial datatypes
Support for MySQL Spatial datatypes so that they could be read and written. Geometry is saved as CBLOB field, but not usable as is.
7 votes -
"DEFAULT VALUE" constraint support in TUniLoader
For now, if some of the data I need to load in db I'm not able to calculate all fiellds values, there's no way to indicate TUniLoader to let the DB Server apply the fields "DEFAULT VALUE" constraint if any.
A good way could be to make TUniLoader able to see no value (nor Null) was given to a column (so, still in "Unassigned" state).4 votes -
Adding 'Persistent Indexes' to the TVirtualTable
Could you consider to add the 'Persistent Indexes' to the TVirtualTable ?
In this case the table could be have a few indexes. Inserting/deleting records will modify all indexes. The searching data will use existing indexes without recreating them. Something like in DBF files with several *.ndx files. Before searching the presistent index will be chose by index name and searching will use this index.
At this moment it is possible to use only one index by setting the VirtualTable.IndexFieldNames property. Changing this property recreates the index, and for large table (>3000) takes time.
The 'Persistent Indexes' are used in…
7 votes -
Fastreport support using lazarus
Accessing firebird database from fastreport runtime designer
using lazarus.20 votes -
68 votes
-
7 votes
-
CodeTyphon compatability.
Would love to see the DevArt components have compatibility for CodeTyphon (FPC/Lazarus fork) as well as instructions for installing/compiling.
12 votes -
Add support for the parameter "Enable Cleartext Authentication"
Add support for the parameter "Enable Cleartext Authentication" in TUniConnection. e.g. for best work "The Cleartext Client-Side Authentication Plugin".
12 votes -
Internal Calc fields
Support for InternalCalc fields. This is really usefull feature. And is supported by FireDac and ClientDataset.
5 votes -
InternalCalc fields support
It would be very usefull to have support for fkInternalCalc field types.
It is supported by FireDac and ClientDataset why not UniDAC ?8 votes
- Don't see your idea?