Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

On 4/22/2019 5:06 PM, Eric Selje wrote:

Yes, absolutely appropriate for an ONUPDATE trigger. Insert a new record into the history table before doing the update.

If you want to do this for every field in every table, FoxAudit is the tool of choice. (I don't see it on TakeNote.com's website any more but maybe shoot an email to Jim Duffy)

I recall FoxAudit, but I use MySQL backends for nearly all of my work.  I avoid DBFs unless I inherit them.

Thanks though!

--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus