On Jul 3, 2008, at 8:45 AM, Martin Bowes wrote:
> Hi All,
>
>
>
> I quote from the SQL reference guide…
>
> If the rule uses the BEFORE keyword, it fires before the INSERT is
>
> executed. This can be used to alter the value of the name or addr
> columns
>
> (for example, after validating them against another table).
>
>
>
> How do I get a procedure to alter the value of a column in a row
> (yet to be inserted in the table)?
>
Use OUT or INOUT procedure parameters. The syntax ought to be doc'ed
in the SQL reference -- if not, I can dig around a little.
Karl
