Re: query from trigger

Jon Erlend Dahlen (jonda_at_ifi.uio.no) wrote:

> starshtr_at_wam.umd.edu (Cowboy) writes:
 

> > I wish to generate a query, activated from a post-block
> > trigger, that will setup the next block automatically with
> > data when navigating to the next block.
 

> Is it not possible to place the query in the pre-block trigger of the
> next block? An execute_query in the pre block trigger of the 'next
> block' will fill the fields...

Ye Gods! Why not try finding out what the error message meant? Execute query is a restricted package procedure. Therefore, pretty much, you can only use it on KEY triggers (there are probably a few more places you can use it, but I can't be bothered remembering the details atm).

So what you want to do is put it on the KEY-NXTBLK trigger, which should read something like:

NEXT_BLOCK;
IF NOT FORM_SUCCESS THEN
  RAISE FORM_TRIGGER_FAILURE; /* In case the next block failed); END IF;
EXECUTE_QUERY;

--
  _________________________   _______________________________
 /  Tommy Wareing          \ / 'Happy, happy. Joy, joy!'     \
|  p0070621_at_brookes.ac.uk   X      said Ren & Stimpy          |
 \  0865-483389            / \ (Supplied by Simone, not me!) /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~