71 results found
-
proper support for connections in threads so transactions can be used
Connection Pooling should work in multi threaded environments with transactions.
I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…6 votes -
They should have a component that imports data from excel, csv, or text into a table and that supports large files.
They should have a component that easily imports data from excel, csv or text into a table and that supports large files.
3 votes -
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 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 -
Extension of PostGreSQL to support multiple hosts
With PostGreSQL it is possible to specify multiple host components, each with an optional port component, in a single URI. A URI of the form
postgresql://host1:port1,host2:port2,host3:port3/is equivalent to a connection string of the form
host=host1,host2,host3 port=port1,port2,port3.Each host will be tried in turn until a connection is successfully established.
I'd like UniDAC to support this approach.
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 -
dbMonitor shows string fields as <BLOB:19> Should show the actual data
dbMonitor, which is a great feature, shows any string values as <BLOB:19> instead of the actual data in that field. This might only apply to postgresql
3 votes -
TfrxUniDACComponents Suport For Lazarus
Looking in the "UniDAC\Demos\ThirdParty\FastReport\" folder, I found a component: "TfrxUniDACComponents", which integrates Unidac with FastReport for Delphi, but I didn't find it for Lazarus. I'm using Lazarus 2.2.6 and would like to know if it's possible to develop this component for Lazarus as well.
3 votes -
Direct Json result from Db driver (no Dataset)
For remote server with REST we need a FAST Json result from Db driver, direct, avoiding dataset marshalling.
3 votes -
TUniLoader with Firebird - automaically calulate maximal value for RowsPerBatch
For Firebird the possible value for RowsPerBatch depends on the number of rows in the table because the maximal length of an SQL statement is 64KB.
For RowsPerBatch=0, UniDac should calculate the maximal possible value itself.2 votes -
Add functionality to allow compacting a Jet 4.0 (Access) database
Currently it is not possible to use UniDAC to compact an existing Jet database.
2 votes -
creating native provider for advantage database
The ODBC-provider for ADS has some restrictions, for example can't access encrypted free tables).
Also FireDac has already an native provider for ADS.1 vote -
Автогенерация InsertSQL, UpdateSQL
Я знаю, что у TUniQuery есть возможность сгенерировать доп. запрос на основе SelectSQL.
Но это неочевидно, в справке нет. Нет готовых методов.
Приходится открывать предварительно сам запрос, что есть не совсем правильно.[code] UniQuery1.Open;
UniQuery1.SQLUpdate.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stUpdate, true);
UniQuery1.SQLRefresh.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stRefresh, true);
[/code]
да и без UniQuery1.Open вываливается AV :(Было бы здорово, если бы было что-то вроде:
UniQuery1.GelerateAllSQLs.
UniQuery1.GelerateInsertSQL;
UniQuery1.GelerateUpdateSQL;
UniQuery1.GelerateDeleteSQL;
и т.д.
и без обязательного открытия набора данных.1 vote -
Автозагрузка свойств поля TField
У компонентов FIBPlus есть замечательная фича.
Когда в базе (Firebird) меняешь размер поля, то не нужно корректировать этот размер у DataSet компоненты. Компонента (TpFibDataSet) сама подтянет новый размер поля в дизайнтайме.
Было бы здорово, чтобы компонента TUniQuery тоже такое умела.
Вообще, желательно, чтобы подгружался не только размер поля, а и другие параметры и не только текстового.
Я работаю с UniDAC примерно с 2012 г и удивлён, что этой фичи ещё нет.
У FIBPlus много вкусного, жаль, что они больше не развиваются.Под словом "подтягивать" я имел ввиду брать из базы, из системных таблиц читать разные параметры поля и применять их…
1 vote -
Add delta support like Firedac for cachedupdates, better yet as a Tunidatasetoption
Your implemantation of cached updates with Updatebatchsize is super fast in comparison to firedac. But sometimes we need to see query delta to apply changes to other datasets without using stored procedures.
1 vote -
Add futures for autostart transactions
Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc
1 vote -
Migration Wizard (Strip the .DB from tablenames if Paradox)
When converting from Paradox to SQLite, I ran into 2 problems.
1) the TableName.DB I used in paradox does NOT have a .DB ending in the actual tablename...
2) The data module where the "database1" was declared for the TUniConnection was not included in the files, and then the connections were not set to them. I had to open all the forms and remove the .db and set themI think that the Migration Wizard should handle those better...
1 vote -
The ability to create views with identical field names.
It will not take over the identical field names of a view. If multiple fields have the same name located in different sub-tables of this view.
1 vote -
1 vote
-
Add desing time support for custom SQLite functions with UniDAC.
When you add a new sql function at runtime (TLiteUtils.RegisterFunction) you can't use it at design time in a UniQuery because the function is unknown.
1 vote
- Don't see your idea?