Subject Re: ROW_COUNT
Author kumasoftllc
Where is the README.context_variables.txt file to which you refer?

It does not seem to be included with the 1.5 RC4 download.

Thanks.


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 11:15 AM 1/08/2003 +0200, you wrote:
> >Helo!
> >
> >How can I use ROW_COUNT in my stored procedure? I have an UPDATE
in it.
>
> From the README.context_variables.txt:
>
> UPDATE TABLE1 SET FIELD1 = 0 WHERE ID = :ID;
> IF (ROW_COUNT = 0) THEN
> INSERT INTO TABLE1 (ID, FIELD1) VALUES (:ID, 0);
>
> heLen