246 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 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 -
Add ability TMSDump to dump all of database (not only data) to sql script. i.e schema - create statement, sp,triggers, etc.
The same functionality which has dbforge studio or ssms.
1 vote -
Implmentation of MSSQL Active Directory Authentication
dbExpress driver for MSSQL with Active Directory Authentication.
Customers want to connect to Azure MSSQL database. Only AD Authentication is allowed.
Maybe same idea as https://devart.uservoice.com/forums/104635-delphi-data-access-components/suggestions/34764841-implementation-of-the-new-authenticatthod-of-newer, but for dbExpress SQL Server driver.
17 votes -
27 votes
-
Add futures for autostart transactions
Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc
1 vote -
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 -
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 support for Direct Mode SQLite with FTS5 enabled.
Include SQLite extensions like enable FTS5 in direct mode connection in UniDac.
5 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 -
Lazarus frxODACComponents
Fast Report in Lazarus frxODACComponents is not included in the set of our componente when using the Lazarus environment
58 votes -
Allow more than 150 procedure parameters.
Change TOCICommand.InitProcParams7 MaxParams constant to 250
3 votes -
Direct mode OraQueue AsyncNotification support
Add Async notifications support to OraQueue in Direct mode.
4 votes -
Add Support For SQL Server "Always Encrypted"
SQL Server now has a new security feature called "Always Encrypted". This is a recognised Microsoft solution for encrypting certain sensitive database columns to meet European Union GDPR regulations. Please add "Always Encrypted" support into Devart SQL Server data access components. This is a recognised approved solution to SQL Server DBA's.
1 vote -
Автозагрузка свойств поля 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 -
Fix TMyDump
TMyDump.Backup() writes all Views in alphabetical order. However, if there are inter-joins among Views the database may not be restored, as the Views must be restored according to their dependencies.
I strongly suggest fixing TMyDump.Backup. The algorithm should analyze the dependencies among Views and account for the correct order of joins.
1 vote -
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 -
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
- Don't see your idea?