🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: WHEN DO Statement

#945
From: Patrick Moloney
Date: Wed, 21 Mar 2007 16:03
27 lines
1905 bytes
Martijn Tonies wrote:

> Patrick, try:
> 
> when gdscode lock_conflict do
> 
> It's the normal isc_ code, without the isc_ part.

AMAZING!!! How would you ever think to specify only part of the
documented code?
And, who would ever make something work like this?  Anybody from
Codegear feel free to jump in here!
Anyway, this saves (compiles) the stored procedure. No error for
unknown identifier. But I can't tell how it's working.
If I say WHEN ANY and write out a test string my error is trapped and
the test string writes out.  If I say WHEN GDSCODE exception_name, my
error is trapped, but the test string doesn't write out. I know I get
an IB Exception Message without the WHEN, but I'm not sure what
GDSCODE, if any, is actually being thrown. I thought this last would
trap only that one code. So, I'm not sure how well IB is even working
with this.
Any idea how to identify the error that the When statement is
receiving?, or the associated message.
Even if I can get this to work, I need the error message.

-- 
Patrick Moloney
Technical Details
Message-ID: <4601492d$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.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
References: <45fec3cb$1@newsgroups.borland.com> <460029e9@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,9d0db194da8efd84
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m>
Subject: Re: WHEN DO Statement
Newsgroups: borland.public.interbase.sql
Reply-To: "Patrick Moloney" <NewsID@SandrockSoftware.com>
References: <45fec3cb$1@newsgroups.borland.com> <460029e9@newsgroups.borland.com>
User-Agent: XanaNews/1.18.1.3
NNTP-Posting-Host: 151.204.132.253
Message-ID: <4601492d$1@newsgroups.borland.com>
Date: 21 Mar 2007 08:03:09 -0800
X-Trace: newsgroups.borland.com 1174489389 151.204.132.253 (21 Mar 2007 08:03:09 -0800)
Lines: 27
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.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