Subject | Help with triggers... |
---|---|
Author | Allysson Costa |
Post date | 2007-08-02T17:30:03Z |
Dear friends,
I'm trying create a trigger to update a field in a table at "after update" event from other table.
I have student and vacancy(available position at class) tables. Then I need that, when updating a field in student table, make other update in vacancy table.
Can I use student field "id" like input parameter inside the trigger or I must use procedures?
Any help.
Thanks.
Allysson
Flickr agora em português. Você cria, todo mundo vê. Saiba mais.
[Non-text portions of this message have been removed]
I'm trying create a trigger to update a field in a table at "after update" event from other table.
I have student and vacancy(available position at class) tables. Then I need that, when updating a field in student table, make other update in vacancy table.
Can I use student field "id" like input parameter inside the trigger or I must use procedures?
Any help.
Thanks.
Allysson
Flickr agora em português. Você cria, todo mundo vê. Saiba mais.
[Non-text portions of this message have been removed]