I have a collector window that I am hooking another process onto.
Basically, if a record is set up in Table A, the Save process on the collector checks Table B for a record. If there is no record in Table B, it displays an error message, sets WC_VALID% to false, and bails out.
This would all work fine and dandy if I was only calling this one process from the Save hook. However, there is a system routine that is also called from the Save hook, and I have these two processes chained together using a semi-colon.
My process is called first, because I want to be able to interrupt things if the record does not exist in Table B. However, even though I am setting WC_VALID% to false, the next process in the chain is still firing.
How can I prevent the system from calling the next event?
TIA,
Catalyst does not respond to window common variables. To exit set @Ans to 1 (I think - sorry it has been a while so you might have to confirm this as although I'm sure it's in REVMEDIA somewhere I can't find it :(…)
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
And once again the might Sprezz comes through.
For those that are interested, I present the following clicky.
Oh, and it says I'm supposed to ask how you know . . . . .
*grin*
That worked perfectly!!!
Between that little trick and playing around with VSpace, I have learned quite a bit on this little project.
Gotta love those new SOX (Sarbanes-Oxley) rules.
*thud*
Sheesh yes, spent hours tracking that one down. For me at the time it was very undesirable behaviour :).
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
I was just telling someone else about how you most likely ran across that.
I can just imagine the following thought process:
Let's see, I'm doing this check and I need to know what happened.
I know, I can set @Ans to true or false, then my next routine can check this to see if it's okay to continue.
Hey, WAIT JUST A MINUTE!!!
I told my routine the check passed, but it bailed out.
I can see where that would be very frustrating :)
Give that man a ceegar!
The Sprezzatura Group Web Site
World Leaders in all things RevSoft