🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #1036

WHEN DO Statement

#1036
From: Patrick Moloney
Date: Mon, 19 Mar 2007 18:09
21 lines
1946 bytes
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 Moloney
Technical Details
Message-ID: <45fec3cb$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,9d0db194da8efd84,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m>
Subject: WHEN DO Statement
Newsgroups: borland.public.interbase.sql
Reply-To: "Patrick Moloney" <NewsID@SandrockSoftware.com>
User-Agent: XanaNews/1.18.1.3
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 151.204.132.253
Message-ID: <45fec3cb$1@newsgroups.borland.com>
Date: 19 Mar 2007 10:09:31 -0800
X-Trace: newsgroups.borland.com 1174324171 151.204.132.253 (19 Mar 2007 10:09:31 -0800)
Lines: 21
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail