>I know that the full blown version of what I want to do is called an audit trail. What I would like is a simple method for tracking program flow in a small section of the code to see if code is being executed or not (in this case if tables are update or if a roll back occurs). I quess the closes thing I can think of is a code profiler which if I understand VFP correctly is not available at run time. That is why I wanted to create a text file for a short time. Textmerge way be the way to go.
I think you can quickly create a primitive audit trail, which simply lists the changes done, and apply it to a few tables.
You can leave a more sophisticated version (including rollback and roll-forward options) for later, or for a commercial product.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)