Subject | Re: Execute Statement & Row_Count in SP |
---|---|
Author | constantijnw |
Post date | 2004-06-18T15:10:32Z |
--- In firebird-support@yahoogroups.com, constantijnw <cw.s@x> wrote:
Hopefully this feature will be implemented in future.
> Hi,has
>
> 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
> 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