Triggers and updates to multiple tables [message #39285] |
Wed, 03 July 2002 03:03 |
luke
Messages: 6 Registered: July 2002
|
Junior Member |
|
|
Hi,
I have a trigger on one table that needs to be able to see changes made to other tables in the same transaction. The table the trigger is on is however not necessarily the last table to be updated in the transaction.
Is this possible?
At the moment the trigger does not seem to be able to see the changes to the satellite tables, only the changes on the table the trigger is on. I have tried using before and after triggers but this hasn't made a difference (should it have?).
Any suggestions?
Thanks in advance for any help.
Luke.
-----
|
|
|
|