🚀 go-pugleaf

> Does anyone know if the WHEN DO statement actually works for SQLCODE,
> Exceptions and GDSCode errors, as documented.  All examples in the
> documentation show SQLCODE being used, as is most common.  But in
> trying to use Exceptions, and especially GDSCODE, I get errors that
> seem to indicate those options don't work. I have tried with quotes and
> without, using the code and the number for GDSCODES.  The
> documentation, again, isn't too specific. In fact, in the Language
> guide (pg 3-18) the When Do syntax indicates "GDSCODE errcode".  The
> following table provides a "Description" of GDSCODE errorcode as "An
> InterBase error code number".  Table 6.5 list columns for "Error code"
> and "Number".  BTW the Number ends in a Letter.  So, not quite sure
> what needs to be entered into sql code, but I think I have tried
> everything.
> The following section in the Language guide (pg3-20) "Handling
> Interbase error codes" says a "... procedure might receive an InterBase
> error code, isc_lock_conflict." Then provides an example showing When
> SQLCODE!
> Does anyone know if this statement works?

Patrick, try:

when gdscode lock_conflict do

It's the normal isc_ code, without the isc_ part.


-- 
Martijn Tonies
Database Workbench - the IBConsole alternative!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com