Home » Developer & Programmer » Forms » how to moineteing the updating of data (form developer 6i second release)
how to moineteing the updating of data [message #297749] Sun, 03 February 2008 05:21 Go to next message
Messages: 92
Registered: October 2007
Location: Iraq
Dear All

I want to moniter the entering data of a user
I mean if the user enters data and before he commit he made change of the data
i want to know the data he entered and updated before he commits

best regards
Re: how to moineteing the updating of data [message #297751 is a reply to message #297749] Sun, 03 February 2008 05:42 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create BEFORE INSERT / BEFORE UPDATE database triggers which will insert "old" records into the "archive" table. This "archive" table might look exactly the same as the original one, but you might add "timestamp" and "who did that" columns so that you'll gather some extra information.

Or, if you don't like this approach, enable database auditing.
Previous Topic: how to find errors occured during execute_query
Next Topic: How to convert the number to time and time back to number?
Goto Forum:

Current Time: Wed Oct 26 22:37:19 CDT 2016

Total time taken to generate the page: 0.11050 seconds