Subject | Re: ROW_COUNT |
---|---|
Author | kumasoftllc |
Post date | 2003-08-01T11:26:08Z |
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:
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:in it.
> >Helo!
> >
> >How can I use ROW_COUNT in my stored procedure? I have an UPDATE
>
> 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