Article View: borland.public.intrabuilder.data.sql
Article #19Clearing an Exception
From: Jelonek, Joe
Date: Tue, 02 Dec 1997 00:00
Date: Tue, 02 Dec 1997 00:00
18 lines
1378 bytes
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-mailShow 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