| Audit column names in trigger [message #370943] |
Fri, 10 March 2000 09:05 |
Bernhard Zengerle
Messages: 1
Registered: March 2000
|
Junior Member |
|
|
following problem:
I'd like to create an update trigger that audits any actions on a certain table (option: for each row).
However the trigger should access the following information items :
- table name (could be hard coded - no problem)
- old value (no problem)
- new value (also no problem)
- column name (target of update action -> BIG PROBLEM!!!!)
I don't want to use any old vs. new string concatenation followed by analysing, what has changed (table contains more than 100 cols and I'm too lazy to create such a string)
any suggestions?????????
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
