243 results found
-
To Know what is the Number for new Transaction ( TransactionID)
In FIBPLus we have Tr.TransactinID => number for new transaction after StartTransaction execution.
4 votes -
Allow using SYSDATE or subselects for specific fields
Add 2 new String properties to TField containing text used for SQLInsert/SQLUpdate statements.
This allow using SYSDATE or subselects without need of consructing whole SQLInsert or SQLUpdate. Property can be emptystring or null by default.4 votes -
Add property AutoStartTransaction
To control the implicit transaction
4 votes -
Simple Example Code for the components
Put some simple sample code into the help/demos files, that must be great. some times that be very usefully
4 votes -
Extend TIBCLoader beyond event driven design when loading data.
Currently TIBCLoader allows only to Load data by handling particular events. If I want to save something to database I need to handle OnPutData event. Unfortunately this solution requires usage of global variables because to know what I want to insert I need to look for some data beyond the scope of an event.
Even the simple demo of yours shows this problem. You are using a global variable Count to know how much data you want to put it. Rest of the data you are using in a demo is random so it could be generated locally in the…
4 votes -
Add compression ability to saveToStream/file of TVirtualTable
I think, the memoryTables are most usefull as secondary tables whith data saved in master tables as BLOBs.
In this case, is big advantage to be saved compressed.
Maybe this behavior is better to be default as it saves space and time.4 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 -
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 -
4 votes
-
Direct mode OraQueue AsyncNotification support
Add Async notifications support to OraQueue in Direct mode.
4 votes -
Support for OpenSSL 1.1
UniDAC currently only supports OpenSSL 1.0.2. This version won't be supported past 2019-Dec-31.
To avoid problems UniDAC should support OpenSSL 1.1
4 votes -
csv
Dar soporte para archivos csv
4 votes -
Properties From MyDAC
It would be Nice to have implementation of:
- TUniQuery.CommandTimeOut
- TUniQuery.Options.NullForZeroDate4 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 -
UNIDAC to support multiple connection pools in one application
It would be great if UNIDAC could allow the use of multiple connection pools. For example I need two connetion pools to 2 different databases at the same application. This is currently not supported in UNIDAC
4 votes -
4 votes
-
Native driver for Filemaker Server database
The only way to access a Filemaker Server database is via ODBC, which is not supported in iOS. There is a large installation of Filemaker databases out there, backed by Apple, and with the increasing market share of Mac, iPad and iPhone, it will likely gain in popularity.
3 votes -
TMSQuery. Debug SQL generator in design time
There is a button "Execute" on the SQL tab of TMSQuery components, and I can test query in design-time with its help.
But there isn't such button on UpdateSQLs tab. I have to build and run my application to debug SQLInsert, SQLUpdate, SQLDelete properties. It's uncomfortable.I would like to add button "Execute" into all tabs.
3 votes -
populate fields inside watches window
It would be great if I can simply right click on a table component (TIBCQuery in case of IBDac) and choose a command to display list of fields and select some of them or all then after press on ok all these fields added to the debugger watches window in format of <module>.<table>.FieldByName('Field_Name').As<Proper Data Type>
This way I can quickly add watches for many fields from as many tables as I want at a single click and debug become more easier and faster
3 votes -
Manually parse SQL for MBCS strings
Manually parse SQL for MBCS strings.
Latest UniDac MBCS specification is not full compatible with BDE/DBX(Delphi Ansi version).
and issue parse exception by mistake and macro function character at not ParamCheck.
and this exception is difficult to understand the cause.
(I have send details to support already)Please add the following property/Event.
- SkipParseSQL property
- OnBeforeParseSQL
- OnSQLParseError
3 votes
- Don't see your idea?