🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #19

Clearing an Exception

#19
From: Jelonek, Joe
Date: Tue, 02 Dec 1997 00:00
18 lines
1378 bytes
  To test my code I press a button that does some selects and then an
Insert that is a duplicate.  For some reason DBException does not catch
the database error but Exception catches it.  My DBException catch is
before my Exception catch.  Anyways, I loop through the e.errors array
sending alert's.  The user then changes the data so that the Insert will
NOT be a duplicate.  The program errors on setting query1.sql = true.
Where query1.sql is a select!  Once again I catch an Exception for a
duplicate Insert (on a select).
  I have tried recreating the exception variable as the 1st line of code
with no luck.  What do I have to do to reset the Exception error handler
such that my select will not fail as a duplicate Insert?
  Thanks in advance

Joe Jelonek
Gynecologic Oncology Group Statistical Office
Roswell Park Cancer Institute
jelonek@gogstats.med.buffalo.edu
Technical Details
Message-ID: <B4B9FF39E5B3CF119DA300000000000102A5A8@gogstats.med.buffalo.edu>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,b3173c7b6132dfe3,start
X-Google-Attributes: gid101d9a,public
From: "Jelonek, Joe" <Jelonek@gogstats.med.buffalo.edu>
Subject: Clearing an Exception
Date: 1997/12/02
Message-ID: <B4B9FF39E5B3CF119DA300000000000102A5A8@gogstats.med.buffalo.edu>
X-Deja-AN: 294563123
Sender: "Jelonek, Joe" <Jelonek@gogstats.med.buffalo.edu>
Organization: None
Keywords: Exception
Newsgroups: borland.public.intrabuilder.data.sql