Plx help...handle more then one exception in procedure individually

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by NEWBIES Wed, 11 Dec 2002 03:11

#11204

Author: NEWBIES
Date: Wed, 11 Dec 2002 03:11

22 lines
1550 bytes

I wish to catch and handle exception in procedure individually, I do the
following:
------------------------------------------------
When any do
Begin
   if (GDSCODE = unique_key_violation) then
        exit;
   if (GDSCODE = arith_except) then
        exit;
End
------------------------------------------------
The Error window tells
"Dynamic SQL Error
SQL error code = -104
Token unknown - line 16, char 11
GDSCODE"

p.s:  If there is alternative way suggested such as query system tables for
error code..etc..I will aalso welcome.   What I need here is to ignore this
two exception.
Please help.  Thank you very much inadvance
Newbies

Please do not multi-post

#11211

Author: Craig Stuntz TeamB
Date: Wed, 11 Dec 2002 15:44

17 lines
1530 bytes

In article <3df6acfa$1@newsgroups.borland.com>, newbies@netvigator.com 
says...
> I wish to catch and handle exception in procedure individually, I do the
> following:
> 
	Multi-posted.  Ivan Prenosil answered this in 
borland.public.interbase.general.  Please do not multi-post.

	Thank you,

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads