Trigger on a Table [message #20029] |
Thu, 25 April 2002 09:07 |
Arpit
Messages: 99 Registered: March 2001
|
Member |
|
|
Hello All,
I need some help in order to write a trigger on a table.
In one of my tables when the record is modified, it doesn't change the "date_modified" for the record. I need to force it to have the "date_modified" for any update on records defaulting it to the system date.
How can i write a trigger on this particular table forcing it to assing the "date_modified" to system date.
Any help on this would be highly appreciated.
Thanks
|
|
|
|
|