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 -
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 -
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 -
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 -
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 -
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 -
Fastreport support using lazarus
Accessing firebird database from fastreport runtime designer
using lazarus.20 votes -
Implement Connection.QueryValue()
FIBPlus have a great and simple way to quickly ask databse about value or set of values, this method is called QueryValue. If I want to ask database for only one row, I do not want to create a dataset for it. It causes a big overhead.
Instead I would like to ask for a value like this:
MyValue := Connection.QueryValue('SELECT TOP 1 USERNAME FROM USERS WHERE SURNAME = :SURNAME', [Surname])
5 votes -
Adding OnFieldChange event and the CloneCurrentRecord.
Hello, I would appreciate (for easy migration from FIB+ to your component suite) adding OnFieldChange event and the CloneCurrentRecord.
13 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 -
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 -
Extract table metadata information
Extract a whole table metadata information, like ibx / IBExtractExtractObject.
It's useful for example replicate a table.22 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 -
21 votes
- Don't see your idea?