Subject Help with triggers...
Author Allysson Costa
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]