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 -
Автозагрузка свойств поля 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 -
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 - Integrated48 votes -
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 -
4 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 -
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 votes -
Install directories
You guys use several uncommon directories for 3rd party components : 1: windows\System32 for some BPL
2: Delphi\Lib for some dcp
3: Delphi\Bin for some other BPL
4: UniDAC for dcuHow about using
BDSCommon\BPL for all bpl
BDSCommon\DCP for all dcp
leaving the dcu in the lib of the unidac install directoryTo explain : As a developer i work with several virtual PCs that I have to update. I use a local SVN for that. Installing unidac is always a hassle because after the install I first have to copy everything where it's supposed to be and then…
1 vote -
Monitoring every events (insert, edit,..)
Add monitoring feature to uniDac to let developers monitor each events occured to MySQL database (insert, update, delete..) and return the result.
1 vote -
Ability to localize TCRDBGrid
CRDBGrid have only one popup where it shows "Filtered", "Filter Bar", "Search Bar" as a text and everything else is pictures on it. Or, field names which can be set by programmer.
It would be nice to be able to localize these texts in the object inspector. Should be pretty easy to implement, and would be a nice addition to the component.
0 votes -
vba
sometimes user adding in access mdb, accdb query a vba function , so i hope that could the access query using vba function executed also on delphi
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 -
More control on Connection Pooling in Unidac Components
Timeout for connection pooling is fixed for 30000 ms in Unidac ( It is a local constant variable). It is not enough for some applications. We need more control on connection pooiling. It would be better if developer could set timeout as a property.
6 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 -
Add savetoJSON to uniquery
As JSON more popular。
It's time to support JSON in uniquery.43 votes -
Adding comment feature as property to UniDAC components
Add a "comment" property to possible UniDAC components. It could be very helpfull to add comments to TUniConnection, TUniQuery, TUniTable, ... because technical names are often short or meaningless and a comment can translate it into a meaningful description.
8 votes
- Don't see your idea?