Hi,

At August 6, 2003, 04:00, alescurk wrote:

>> UPDATE TABLE1 SET FIELD1 = 0 WHERE ID = :ID;
>> IF (ROW_COUNT = 0) THEN
>> INSERT INTO TABLE1 (ID, FIELD1) VALUES (:ID, 0);

> When I try to do these it returns me "Invalid token ROW_COUNT". I have
> FB 1.5 RC3 and usinx IB Expert 2.5.0.49 Personal edition. What could
> be a problem????

I would suspect that IB Expert is not up to date. Because I'm certain
that you are getting the error during IB Expert pre-compile stage, and
at that point, I think, nothing is sent to the server. So, the error
is generated by IB Expert and not Firebird.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)