October 8th, 2010, 10:08 AM
-
New to firebird: exception propogation
I created 2 procedures as follows:
(this is like pseudocode)
proc1: validate_data. if not valid data exception;
this works fine I get an exception when I run invalid data.
proc2: insert_data. exec validate_data, insert data.
in proc2 exception from proc1 does not work and data is inserted whether valid or not.
question: How are exceptions propogated from lower level proc to higher level proc in Firebird?
I would have thought that exception if not handled should propogate all the way up to the client.
October 9th, 2010, 06:17 AM
-
yes, you know it right...it's pop up technique....if you don't handle it in lower levels it will reach the client and show up at the user interface if you don;t handle it in the client layer either
Originally Posted by irusoh
I created 2 procedures as follows:
(this is like pseudocode)
proc1: validate_data. if not valid data exception;
this works fine I get an exception when I run invalid data.
proc2: insert_data. exec validate_data, insert data.
in proc2 exception from proc1 does not work and data is inserted whether valid or not.
question: How are exceptions propogated from lower level proc to higher level proc in Firebird?
I would have thought that exception if not handled should propogate all the way up to the client.