Subject | Global trigger? |
---|---|
Author | Paul R. Gardner |
Post date | 2006-04-13T13:53:27Z |
I apologize if this email has gone through twice. I cannot seem to get
questions to post onto the website by emailing them. I'm trying once
more.
***
[ Joining the list was a good move, then. :-) -- Moderator ]
***
I have a database with roughly 100 tables. I want to add a TIMESTAMP
field called LASTUPDATED into each table. Next, I'll have a Trigger
Before Update/Insert that says:
LastUpdated = current_timestamp;
Is there any way to do this without 100 different triggers? Some sort
of trigger on a RDB$ table that runs each time?
Thanks,
Paul Gardner
gardnerp@...
[Non-text portions of this message have been removed]
questions to post onto the website by emailing them. I'm trying once
more.
***
[ Joining the list was a good move, then. :-) -- Moderator ]
***
I have a database with roughly 100 tables. I want to add a TIMESTAMP
field called LASTUPDATED into each table. Next, I'll have a Trigger
Before Update/Insert that says:
LastUpdated = current_timestamp;
Is there any way to do this without 100 different triggers? Some sort
of trigger on a RDB$ table that runs each time?
Thanks,
Paul Gardner
gardnerp@...
[Non-text portions of this message have been removed]