75 results found
-
dbMonitor and TUniQuery - final SQL without parameters
dbMonitor
Please add another tab next to the tabs "SQL, Parameters, Error, CallStack" e.g. "Final SQL" in which we would be able to see SQL query with real parameter values instead of parameter placeholders ":Param1, Param2,...".
Please show real value of MEMO fields (TEXT - PostgreSQL, BLOB SUBTYPE 1 - Firebird, etc.) in parameters tab instead something like <BLOB:xxx>.
For real BLOB types (BLOB SUBTYPE 0 or BINARY) you can leave <BLOB:xxx>
TUniquery
Please add some property (like FinalSQL) but with real parameter values instead of parameter placeholders ":Param1, :Param2,...", so we can see actual SQL when debugging from Delphi…
3 votes -
Support out params in ANONYMOUS BLOCK for PostgreSQL
DO $block$ begin :c:=100; end; $block$
This works for Oracle, but not for PostgreSQL
3 votes -
Support TDataset.FieldOptions (AutoCreateMode) in Unidac
Please implement the support of AutoCreateMode in your components.
Further description:
http://docwiki.embarcadero.com/Libraries/Rio/en/Data.DB.TFieldOptions.AutoCreateModeWith this option it's possible to create calculated fields in design time and all other fields will be added automaticly on runtime.
3 votes -
Manually parse SQL for MBCS strings
Manually parse SQL for MBCS strings.
Latest UniDac MBCS specification is not full compatible with BDE/DBX(Delphi Ansi version).
and issue parse exception by mistake and macro function character at not ParamCheck.
and this exception is difficult to understand the cause.
(I have send details to support already)Please add the following property/Event.
- SkipParseSQL property
- OnBeforeParseSQL
- OnSQLParseError
3 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 -
Native driver for Filemaker Server database
The only way to access a Filemaker Server database is via ODBC, which is not supported in iOS. There is a large installation of Filemaker databases out there, backed by Apple, and with the increasing market share of Mac, iPad and iPhone, it will likely gain in popularity.
3 votes -
proper support for connections in threads so transactions can be used
Connection Pooling should work in multi threaded environments with transactions.
I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…6 votes -
Use TMonitor instead T(RTL)CriticalSection
Since the latest delphi has resolved all the major bugs of TMonitor and it's stable it would be nice to use it instead of T(RTL)CriticalSection.
It's way more faster locking so more performance gains of UniDac and our apps.
You case you Defines to change the lock mechanism for older versions of Delphi.
3 votes -
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 votes -
Direct Json result from Db driver (no Dataset)
For remote server with REST we need a FAST Json result from Db driver, direct, avoiding dataset marshalling.
3 votes -
TfrxUniDACComponents Suport For Lazarus
Looking in the "UniDAC\Demos\ThirdParty\FastReport\" folder, I found a component: "TfrxUniDACComponents", which integrates Unidac with FastReport for Delphi, but I didn't find it for Lazarus. I'm using Lazarus 2.2.6 and would like to know if it's possible to develop this component for Lazarus as well.
3 votes -
dbMonitor shows string fields as <BLOB:19> Should show the actual data
dbMonitor, which is a great feature, shows any string values as <BLOB:19> instead of the actual data in that field. This might only apply to postgresql
3 votes -
Add functionality to allow compacting a Jet 4.0 (Access) database
Currently it is not possible to use UniDAC to compact an existing Jet database.
2 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 -
Add futures for autostart transactions
Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc
1 vote -
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 -
The ability to create views with identical field names.
It will not take over the identical field names of a view. If multiple fields have the same name located in different sub-tables of this view.
1 vote
- Don't see your idea?