Re: Which block trigger in Forms 5.0 permits restricted built-in execute_query ?

Tried that, because I agree that would be correct, problem was that it did process the query correctly essentially allowing the trigger to process the data.

When I get to work today I will grab the code and post it here for all to review more clearly... maybe that will help more.

>
>Maybe try to use PRE-UPDATE instead of ON-UPDATE...?
>
>ON-UPDATE and ON-INSERT are mostly for intercepting the internally-generated
>SQL statements that the form generates for the update and insert statements and
>for you to override them. If you are validating and/or manipulating data in
>database column items programmatically *before* it gets to the database at all,
>you should be using the PRE-XXXX triggers, not ON-XXXXX triggers.
>
>-Matt
>
Received on Fri Jun 02 2000 - 00:00:00 CEST