71 results found
-
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 -
Implementation of the new authenticatthod of newer Microsoft SSMS.
Implementation of the new authentication method of newer Microsoft SSMS:
* Active Directory – Universal with MFA support
* Active Directory - Password
* Active Directory - Integrated48 votes -
Автозагрузка свойств поля TField
У компонентов FIBPlus есть замечательная фича.
Когда в базе (Firebird) меняешь размер поля, то не нужно корректировать этот размер у DataSet компоненты. Компонента (TpFibDataSet) сама подтянет новый размер поля в дизайнтайме.
Было бы здорово, чтобы компонента TUniQuery тоже такое умела.
Вообще, желательно, чтобы подгружался не только размер поля, а и другие параметры и не только текстового.
Я работаю с UniDAC примерно с 2012 г и удивлён, что этой фичи ещё нет.
У FIBPlus много вкусного, жаль, что они больше не развиваются.Под словом "подтягивать" я имел ввиду брать из базы, из системных таблиц читать разные параметры поля и применять их…
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 -
4 votes
-
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 votes -
Add savetoJSON to uniquery
As JSON more popular。
It's time to support JSON in uniquery.43 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 -
68 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 -
TUniMetaData data-types
the TUniMetaData data-type field now returns different data for different databases - Example:
currently for MySql it returns a string e.g. 'float'
but for MS SQL server it returns a number: e.g. 5 (for float fields)so the recommended improvement is to add a new field to the result that returns a string representing the native database type.
this feature is useful if you want to show a list of columns including data-types to the user - it can also be used to generate a create script, etc.
6 votes -
Please update the help file
Please update the help file, and try to be more explicit on the definitions
7 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 -
Implement Support for Raspberry Pi plattaform using lazarus.
Implement support for Raspberry Pi and arm general Iot using lazarus. Im a lazarus user and rapsberry work exceleent with my app. Just need a stable dataaccess like unidac on raspberry pi.
3 votes -
Creat Native "Conection Lost Problem" Events and Alerts
Creat Native "Conection Lost Problem" Events and Alerts
that Unidac by it self can detect the problem in Network and produce
costumizeble Notifications...22 votes -
save TUniQuery to TVirtualQuery and restore quickly
How to save TUniQuery to TVirtualQuery quickly ?
1 vote -
pack data between server(LINUX) and client(Windows)
I would like to develop server program at LINUX(Lazarus) and client program at Windows(Delphi). I need to pack dataset on server site. I am using unidac with sql to access relational database. It is better to save returned dataset to memorystream quickly and transfer the stream to client. Also I want to restore memorystream to uniquery dataset quickly.
1 vote -
After append event
When working with DevExpress VCL Tools the Append and Insert are different, and no im forced to use Insert instead of Append in the CX grid because the append have no corresponding event in Unidac, i cant catch it. The insert and append behaves different in the CX grid.
1 vote -
Implement TStringField.Size restriction
DB table has column varchar(200), in application i want to restrict field size to 50 characters.
In ADO Components TStringField.size restrict string column size, but UniDAC, after open table, discard my TStringField.Size and set it to column size, that column has in DB.70 votes -
Using TVirtualTable replace with TClientDataSet
1.supports Aggregates
2.supports Data And Delta!
3.supports binary formatter data,like TClientDataSet!
4.supports json data!
5.supports SQL Memory.
6.exports updated SQL!
7.Supports Merge Delta Data,Reconcile Delta Data!
8.Every record have Single row number,it can use to locate record!
9.Supports DataSetField!
10.Supports SetOptionalParam/GetOptionalParam347 votes
- Don't see your idea?