| Subject | Re: [firebird-support] ROW_COUNT |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-08-01T10:33:26Z |
At 11:15 AM 1/08/2003 +0200, you wrote:
UPDATE TABLE1 SET FIELD1 = 0 WHERE ID = :ID;
IF (ROW_COUNT = 0) THEN
INSERT INTO TABLE1 (ID, FIELD1) VALUES (:ID, 0);
heLen
>Helo!From the README.context_variables.txt:
>
>How can I use ROW_COUNT in my stored procedure? I have an UPDATE in it.
UPDATE TABLE1 SET FIELD1 = 0 WHERE ID = :ID;
IF (ROW_COUNT = 0) THEN
INSERT INTO TABLE1 (ID, FIELD1) VALUES (:ID, 0);
heLen