Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00307005
Message ID:
00308233
Views:
34
Jim,

>The most complete audit trail I ever built was for a company in NYC. We used a table with three memo fields adn timestamp and user id field. When a use modified a record we did an AFIELDS() and saved teh resulting array into one memo, then we saved the original data into another memo and finally we saved the changed data into the third memo

come again? you saved the before edit data to one memo, after edit data to another memo, < scratching head > and what was in the third memo field?

(Sounds like a much better solution than the vertical table approach I'm used to seeing at my current job.)
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform