WebDB Q: run this SQL after "INSERT"
From: Marcos Leija <marcos.leija_at_cas-mddc.com>
Date: Wed, 19 Apr 2000 15:12:14 -0500
Message-ID: <38FE131E.DFF632A_at_cas-mddc.com>
[Quoted] 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
[Quoted] WHERE first_name='Mary' AND last_name='Williams'; [Quoted] There is nothing wrong with the SQL itself, it's something else.
Date: Wed, 19 Apr 2000 15:12:14 -0500
Message-ID: <38FE131E.DFF632A_at_cas-mddc.com>
[Quoted] 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
[Quoted] WHERE first_name='Mary' AND last_name='Williams'; [Quoted] There is nothing wrong with the SQL itself, it's something else.
[Quoted] I can't get this to work in "Formatting & Validation>Form>...Execute [Quoted] this Code" nor in "Advanced PL/SQL code>... after processing form" [Quoted] [Quoted] 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,
[Quoted] I've never gotten it to work.
Received on Wed Apr 19 2000 - 22:12:14 CEST