Article View: borland.public.interbase.sql
Article #945Re: WHEN DO Statement
From: Patrick Moloney
Date: Wed, 21 Mar 2007 16:03
Date: Wed, 21 Mar 2007 16:03
27 lines
1905 bytes
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-mailReferences:
<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