Subject Re: [firebird-support] Re: ROW_COUNT
Author Helen Borrie
At 11:26 AM 1/08/2003 +0000, you wrote:
>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.

No, you have to go get it for yourself. You'll find it in the Firebird CVS
tree, under ../firebird2/doc/sql.extension (along with a lot of other
useful new stuff).

h.


>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
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/