Devart Forums

AlexP

Hello,

Thanks, we will add this information to our documentation.

AlexP

hello,

This looks like Delphi bug. You can see it in the TSQLStoredProc.PrepareStatement procedure in the SqlExpr.pas file. If you set schema name and package name, the schema name will be lost.

AlexP

hello,

We can't change this behaviour, because other our users need IndexFieldNames to keep its value after reopening the query or changing its SQL text. For example:

Code: Select all

OraQuery.IndexFieldNames:= 'FIELD1';
OraQuery.SQL.Text := 'SELECT 1 AS FIELD1 FROM DUAL'; <-- if IndexFieldNames are reset, as you want, users will not get the expected behaviour
OraQuery.Open;

If you changed this property and then changed query text, it is necessary to reset this property manually.

You can reset needed attributes in the AfterClose Event.

AlexP

hello,

In Delphi 2007 dbExpress was completely changed, thats why its behavior may be other than in Delphi 2006.

To execute a stored procedure under another user, you can create a synonym to your procedure and use it.

Also you can save SqlExpr.pas file in your work directory, and correct TSQLStoredProc.PrepareStatement procedure.

Replace

Code: Select all

if FSchemaName  '' then
SQLText := QuoteIdentifier(FSchemaName + '.' + FNativeCommand, true)
else
SQLText := QuoteIdentifier(FNativeCommand, true);
if FPackageName  '' then
SQLText := QuoteIdentifier(FPackageName + '.' + FNativeCommand, true);

with

Code: Select all

if FPackageName  '' then
SQLText := QuoteIdentifier(FPackageName + '.' + FNativeCommand, true)
else
SQLText := QuoteIdentifier(FNativeCommand, true);

if FSchemaName  '' then
SQLText := QuoteIdentifier(FSchemaName + '.' + SQLText, true);

and add the file to your project.

AlexP

Hello,

Thank you for the information.
We will try to resolve this issue.
Now to resolve this issue you can set UniTable1.KeyFields := '' after closing a table.

AlexP

Hello,

You can't get ErrorCode, because dbExpress work through standard Delphi database classes that don't support the ErrorCode property.

AlexP

Hello,

To leave IBCQuery opened after commit, it's necessary to call the IBCTransaction.CommitRetaining method instead of IBCTransaction.Commit. It's connected with the specificity of Interbase.

AlexP

Hello,

You are right, the DBXCommon unit is available starting from Delphi 2007.
In earlier Delphi versions you can use EDatabaseError.

AlexP

Hello,

We have performed a detailed investigation of the problem. To catch the dbExpress exception you can use
the TDBXError class (it is necessary to add the DBXCommon unit in uses), because in dbExpreess EPgError is replaced by TDBXError

AlexP

Hello.

The default path to PgError.dcu is (your system drive):\Program Files\Devart\PgDac for Delphi 6\Lib, if you install PgDac in another dir, search PgError.dcu in (your instal pgDac directory)/lib

Please check if path to the PgDAC library is available in
delphi->tools->Environment Options->Library->Library Path
....;:\Program Files\Devart\PgDac for Delphi 6\Lib;:\Program Files\Devart\PgDac for Delphi 6\Bin

if this path doesn't exist it is necessary to reinstall PgDAC or add this path manually

AlexP

Hello.

Thank you for the information.

We will fix this bug in one of the next builds/versions.

AlexP

Hello.

To use EPgError Exception it's necessary to add the PgError unit to uses section.

Search found 5532 matches