74 results found
-
Add "Inverse Null Sort" (f.e.: "IN") function to IndexFieldNames
As the "coInvertNullOrder" flag -for client side sorting the dataset- is already imlpemented for some of the providers, it would be nice to be able to control the default method how NULL values are sorted (comes as first or comes as last).
The best approach would be to be able to control this over f.e. with an "IN" postfix in the IndexFieldNames, per field.
Like: "SomeField DESC IN;OtherField ASC"
Thx.
3 votes -
dbmonitor
dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.
3 votes -
Add futures for autostart transactions
Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc
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 -
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 - Integrated49 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...25 votes -
UniDac should support ElevateDb
ElevateDb is a powerful embedded and C/S database and should be supported by Unidac. It has been around for years and has many features found in PostgreSQL, like bi-drectional replication.
13 votes -
save TUniQuery to TVirtualQuery and restore quickly
How to save TUniQuery to TVirtualQuery quickly ?
1 vote
- Don't see your idea?