Re: WebDB Q: run this SQL after "INSERT"

Create a trigger on the table/view where data is inserted an put

UPDATE company.employee
SET age = 6
WHERE first_name='Mary' AND

in the body of the trigger

Luca

In article <38FE131E.DFF632A_at_cas-mddc.com>,   Marcos Leija <marcos.leija_at_cas-mddc.com> wrote:
> In a form, when a user presses INSERT, I would
 like to run some code
> after the button is pressed:
> UPDATE company.employee
> SET age = 6
> WHERE first_name='Mary' AND
 last_name='Williams';
> There is nothing wrong with the SQL itself,
 it's something else.
>
> I can't get this to work in "Formatting &
 Validation>Form>...Execute
> this Code" nor in "Advanced PL/SQL code>...
 after processing form"
> I always get some sort of Line Column Error.
>
> Anyone know the proper way of doing this?
>
> Marcos
> BTW, The SQL code could be anything, select,
 insert, delete, update,
> I've never gotten it to work.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Apr 23 2000 - 00:00:00 CEST