[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.

[nagysz]

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.