>i forgot to ask, is this solution takes more seconds when the table sizes grove day by day ? it seems this solutions right for my needs. why , i want only tracks these actions...
If you mean, will it be slow to add records to the audit table, I didn't have problems with that. Basically, you are just adding one record for each change. The audit table doesn't even have to be indexed, but it shouln't be a problem if it is.
One thing you have to be aware of: the audit table has the tendency to grow faster than any other table. That means that it can be difficult to make regular backups of the audit table (for this reason, I transferred data to a historical table, regularly - keeping audit information for only the last 2-3 months). It also means that you might eventually approach the 2 GB limit, inherent to VFP. Of course, it all depends how many changes are done.
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)
