#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    1
    Rep Power
    0

    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.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    15
    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.

IMN logo majestic logo threadwatch logo seochat tools logo