Is there a list of SQLCODEs available? I guess they're contained in
the firebird.msg file, but a text file would be preferrable.

I'm experimenting with SP's and I have

INSERT INTO WATCH_DOG ( MODULE, BARKED_AT )
VALUES (:MODULE, CURRENT_TIMESTAMP );
WHEN SQLCODE -803 DO
UPDATE WATCH_DOG SET
BARKED_AT = CURRENT_TIMESTAMP
WHERE
MODULE = :MODULE,

but I wanted to try doing it the other way round, i.e. try an update
first and if that doesn't succeed, then try an insert. I assume the
SQLCOde for a failed update is different from a failed insert.

Someone suggested the back of the language guide, but I cannot find
anything there.

TIA

David