Article View: borland.public.interbase.sql
Article #1036WHEN DO Statement
From: Patrick Moloney
Date: Mon, 19 Mar 2007 18:09
Date: Mon, 19 Mar 2007 18:09
21 lines
1946 bytes
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-mailShow 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