Subject Re: [firebird-support] Catching GDSCODE in Stored Procedures?
Author Martijn Tonies
> > > >I thought this should work:
> > > >
> > > > WHEN GDSCODE 335544345 DO EXIT;
> > > >
> > > >But it doesn't, while this does work:
> > > >
> > > > WHEN GDSCODE lock_conflict DO EXIT;
> > > True, WHEN gdscode always did work only with the symbols. Why? don't
> >know.
> >
> >Strange... The InterBase documentation says:
> >
> >GDSCODE errcode An InterBase error code number
> >
> >What does the Firebird docs/book say?
>
> The Firebird book has it right. :-)

Kinda expected that ;-)

So does Database Workbench... or at least, so it does now :-D

>And supplies a full list of gdscodes
> and their symbols, freshly generated from msg.gdb. Also here:
> http://www.ibobjects.com/docs/fb_1_5_errorcodes.zip

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com