Helder Meneses
|
| Posted: 02/20/2002, 5:57 AM |
|
hi there,
i have two tables, one "requisicoes" and the other "eventos" and when i insert the first record on the eventos form i would like to change the field status on table requisicoes to "changed"....how can i do this...please help, its urgent...
thank you...
CodeCharge? great product...
|
|
|
 |
Alex Alexapolsky
|
| Posted: 02/20/2002, 6:07 AM |
|
If you will to retieve id of newly inserted record in After Insert event.
The way you retieve it depends on your database type.
Then in the same event you will need to execute update sql statement :
(asp)
cn.execute(sql)
(php)
$db->query($sSQL)
|
|
|
|
|
