Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update changes
Message
From
16/11/2003 10:32:27
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
16/11/2003 10:18:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00850424
Message ID:
00850428
Views:
17
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
Map
View

Click here to load this message in the networking platform