Re: table level trigger doesn't like 'execute_query'

M Hamilton wrote:

  > BEGIN
> COMMIT_FORM;
> -- Your additional processing here:
> EXECUTE_QUERY;
> END;
I'd suggest one change.

BEGIN
    COMMIT;
    GO_BLOCK ...
    EXECUTE_QUERY;
END; If your form is properly constructed the button you just pressed is in a control block and you don't want to requery the control block.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)