37 results found
-
Natural sort for IndexFieldNames (order 1, 2, 11 instead of 1, 11, 2)
You can order your query/table with the property IndexFieldNames. But if you have an varchar field that contains numbers, the order is wrong. You get:
1
11
2But better would be:
1
2
11This can be done with the "natural sort" algorithm. Please implement it for the use with IndexFieldNames like:
ATable.IndexFieldNames := 'MyField natural';
I know I could sort it with SQL, but I need client side sorting with the property IndexFieldNames.
For natural sort see:
https://en.wikipedia.org/wiki/Natural_sort_order(As far I know Windows uses StrCmpLogicalW to sort file names in that way)
5 votes -
DetailDelay - DetailLoaded - status in Detail table
I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded/refreshed already.
Can you please add here any function, which can check it ?3 votes -
Multithreading : Copy data from query
Hello,
I'am testing multithreading with IBDac. For the moment the solution I have found is :
1) Execute a TIbcquery in a thread
2) Copy the result of 1) into a Memory Dataset (in the main thread) when 1) finished.I would like to know if it possible to do something like Firedac :
https://delphi.programmingpedia.net/en/tutorial/4114/retrieving-updated-tdataset-data-in-a-background-thread
or
https://riptutorial.com/fr/delphi/example/14361/exemple-firedacThe very interesting to transfer data between Query is the property :
Form.FDQuery1.Data := Query.Data;
4 votes -
Support for Firebird 3 item isc_dpb_auth_plugin_list
Add support for Firebird 3 item iscdpbauthpluginlist and iscspbauthpluginlist. At the moment I am not able to specify what plugins are available to log in to Firebird 3.0 (Legycy_auth, Aug, Aug256)
1 vote -
Add cache for default values
FillFieldsDefaultValues (in TCustomDADataSet.DataEvent) procedure is called everytime for a dataset, if Options.DefaultValues is True. It creates a query to get the default values. It might be a good idea to cache the defaults and avoid the query.
11 votes -
27 votes
-
Add beta support for FB 4.0 or at least new data types.
Please add support for FB 4.0 while it is still in beta or at least add support for the new FB data types so that developers could start using them in new applications.
12 votes -
Dbexpress Driver support compression for Firebird 3
Firebird over Internet is very slow, Firebird 3 solve this problem useing compress,please Implement Dbexpress Driver to support Firebird 3 compression
about firebird 3 compress :
http://www.firebirdnews.org/firebird-3-protocol-benchmark/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 -
Add DefaultFormat property to TIBCQuery for Date and Numeric fields.
It would be nice to have more control over display formats for Date and Numeric fields.
So having a DefaultFormats property like FIBPlus has, would be of great value.FIBPlus implementation:
DefaultFormats: TFormatFields;TFormatFields = class(TPersistent)
DisplayFormatDateTime:string;
DisplayFormatDate:string;
DisplayFormatTime:string;
DisplayFormatNumeric:string;
EditFormatNumeric:string;
....
end;3 votes -
TIBCAlerter.Synchronize property
The component TIBCAlerter should have a property called Synchronize to listen for events in the background thread same like TFDEventAlerter component
3 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 -
Transaction should be closed when TIBCQuery (DataSet) is closed, and Transaction was started by that component. Same as IBX TIBTransaction.
When I use TClientDataSet + TDataSetProvider + TIBCQuery and I open the ClientDataSet and also the TIBQuery is opend and closed, but the transaction is automaticlally started but not closed. In a n-tier solution (e.g. DataSnap) I open the ClientDataSet in the the client but have no access to the underlying Query and Transaction which is on the server side.
The TIBTransaction has that feature implemented and is very handy to use.
6 votes -
Fastreport support using lazarus
Accessing firebird database from fastreport runtime designer
using lazarus.20 votes -
TIBCTransaction.OnEnd
Implement TIBCTransaction.OnEnd(Action: TTransactionAction)
This event should fire at any transaction finish action: Commit/CommitRetaining/Rollback/RollbackRetaining.111 votes -
SaveToXml method from tIBCStoredProc or tQuery splited into several files
Sometimes results is to big to be save or more often to be loaded into a tVirtualTable (not enough memory). Solution should be to split the result files into several smaller ones (according to line numbers or size).
1 vote -
DataSet memory Container
My problem today.
I developed a system that is going to be sold to many clients. The problem with firebird nowadays is that anyone can copy the database file and open it in its computer. Using SYSDBA and masterkey the database file can be opened in any computer and then, all your register can be copied.
My dream would be that the user and password could be into the database file and not in the server. But I think this is so far away to come true.
Then, I see a possibility to have all my strings rows encrypted, but…3 votes -
the ability to perform sql queries in the local cache
Возможность выполнять запросы в локальном кеше при установке
значения IBCQuery->LocalUpdate=true1 vote
- Don't see your idea?