Problem with Unidac+Firebird

[Janex]

Hi support.
I found some bug with get RowsUpdated in Firebird 2.5 + UniDAC 6.0.1.
code: TDBAccessUtils.GetICommand(Self).GetProp(prRowsUpdated, v)

If update statement is as "clear" SQL, then all work fine, but
when update statement is IN execute block - GetProp always return 0.
for example:

Code: Select all

UPDATE MYTABLE SET MYROW = 1; 

this work fine, but this:

Code: Select all

EXECUTE BLOCK
AS
BEGIN
  UPDATE MYTABLE SET MYROW = 1;
END

This always return zero via ....GetProp(prRowsUpdated, v) into v

WBR
Janex

[Janex]

Possible to found where is error:

unit IBCClassesUni
procedure TGDSCommand.GetRowsAffected;
In first if..then must be also constant SQL_EX_EXECUTE_BLOCK ...

WBR
Janex

[ViktorV]

Thank you for the information. We have reproduced the problem and investigation is in progress. We will inform you when we have any results.

[ViktorV]

We have fixed this issue, the fix will be included in the next IBDAC build.

[ViktorV]

The new IBDAC build with a fix for the issue is available for download now.