General information
Category:
Coding, syntax & commands
Hi everyone:
Is there an easy way to note the changes in a table to another table without listing old values and new values for every field in the original table? Right now, when someone makes a change to a table, a trigger saves the old values for each field and the new values for each field to a new table. What I would like is a way to know which field changed and only have the old and new values for that field stored to a table (in other words, the table that stores the old and new values would only be 2 columns)
Any suggestions? Thanks.
Paul
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only