Subject Re: Execute Statement & Row_Count in SP
Author constantijnw
--- In firebird-support@yahoogroups.com, constantijnw <cw.s@x> wrote:
> Hi,
>
> In a SP I have the following lines:
>
> .
> .
> EXECUTE STATEMENT
> 'UPDATE ATAB SET ' || UPDATECLAUSE || ' WHERE ' || WHERECLAUSE;
> ROWSAFFECTED = ROW_COUNT;
> .
> .
>
> The DML statement works fine but ROW_COUNT returns 0 even when a row
has
> been updated.

Sorry, reading releasenotes twice is not enough for me.

Hopefully this feature will be implemented in future.



> Doesn't EXECUTE STATEMENT set ROW_COUNT?
>
> Constantijn