249 results found
-
Make it possible to combine the Sqlite3 source code and header files with LiteDAC in the same project
Simply add #ifndef SQLITE3H_ in e.g. LiteCall.hpp.
The location is around line 460:
//-- var, const, procedure ---------------------------------------------------define DACProductName L"LiteDAC"
define SQLiteDLLName L"sqlite3.dll"
ifndef SQLITE3H_
static const System::Int8 SQLITEOK = System::Int8(0x0);
static const System::Int8 SQLITEERROR = System::Int8(0x1);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 -
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 -
save TUniQuery to TVirtualQuery and restore quickly
How to save TUniQuery to TVirtualQuery quickly ?
1 vote -
1 vote
-
Green tick mark for answered queries?
Perhaps it's an idea to have an indicator on each specific post to show whether a topic has been answered?
This could be as simple as a check box indicating the post has been answered - filled in by the original requester when the requester is happy with the response(s).
Once the tick box is completed the post could be flagged with an icon - e.g. a green tick mark - and thus considered 'closed'.
Would help responders to skip those posts already answered and those wishing to find answers to skip those posts that have not yet been answered.…1 vote -
Add refreshquick to PgDAC
The RefreshQuick method (https://www.devart.com/mydac/docs/devart.mydac.tcustommydataset.refreshquick(system.boolean).htm) seems very useful to refresh only the new records from big datasets. Ideally, make it possible to specify the name of the TIMESTAMP field so we don't have to create a duplicate - mine are called "created" for example). Maybe we don't even need the TimeStamp field for Postgresql ?
1 vote -
SqlMonitor : No "...monitoring is started/finished" event
When I create a SqlMonitor but with Active := False the component or unit is sending a string to the monitor to say, that it has started, although it's inactive.
Now imagine that with some 50 or 100 clients and you want to check the SQL of 1 certain workstation.Couldn't that be turned off ?
1 vote -
sql monitor: support query execution
It would be helpful in the SQL Monitor to execute the query I'm seeing to see the result set my app receives.
Sometimes I have to check something where the client is and I place the sql monitor to see, what SQL my app is sending and have to enter with a db explorer to check the sql with the parameters sent, what the result is. It would be cool, if the dbmon could have that built in, because the dbmon already has the sql and the params right there.This would often make my work much easier
1 vote -
Implement ServerMode to Unidac
hi,
Devexpress servermode nearly 10 times faster than unidac native components.
Is there any chance you can also implement servermode into unidac?
thank you1 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 -
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 -
Автогенерация 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 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 -
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 -
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 -
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?