Page 1 of 1

Problem with Unidac+Firebird

Posted: Wed 06 May 2015 08:48
by 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

Re: Problem with Unidac+Firebird

Posted: Wed 06 May 2015 09:14
by 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

Re: Problem with Unidac+Firebird

Posted: Wed 06 May 2015 12:03
by 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.

Re: Problem with Unidac+Firebird

Posted: Thu 07 May 2015 07:21
by ViktorV
We have fixed this issue, the fix will be included in the next IBDAC build.

Re: Problem with Unidac+Firebird

Posted: Tue 23 Jun 2015 09:36
by ViktorV
The new IBDAC build with a fix for the issue is available for download now.