Agreed, but at least if there is some code out there for the logging portion, you wouldn't have to do much on that side.
Paul H. Tarver -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Monday, April 22, 2019 3:21 PM To: profoxt...@leafe.com Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA) Even if somebody's built it for MySQL, I'd still have to code my VFP app to query that History table to show the changes made by who and when. On 4/22/2019 4:05 PM, Paul H. Tarver wrote: > I did a project many moons ago where we used the INSERT, UPDATE and DELETE triggers in a Foxpro 6.0 DBC to track field level changes by users by date and time. It was fairly successful other than making our data very dependent upon maintaining a valid DBC. Later, we extended program by adding a connection to a FirebirdSQL database which was then use by a Java-based web front-end. In the case of Firebird, I found a tools called IBLogManager which did the same thing at a SQL level using the same sorts of triggers. > > I wonder if someone hasn't already created a similar tool for MySQL that you could take advantage of. > > Paul H. Tarver > > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC > Sent: Monday, April 22, 2019 2:34 PM > To: profoxt...@leafe.com > Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA) > > VFP9SP2 app, MariaDB 10 (MySQL) backend. > > One of my clients asked about a history of price changes. Easy enough > to implement programmatically for the few price fields, but then I got > to wondering if simply putting code in the ON UPDATE trigger to send the > old record to a "history" table would be a more complete (and long term > EASIER) solution, whereby my app would query the "history" table for > changes. > > Your thoughts for tracking price (or other) changes? > > tia, > --Mike > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011101d4f953$9fda9090$df8fb1b0$@tpcqpc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.