Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Check into FoxAudit. I think it will produce the list of changes you are looking for. You wouldn't get a lot of value out of such a table except for audit trails.
If you're not prepared to spend some money, you can write table triggers to produce this output when the record changes.
>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
Previous
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