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
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
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
Littlefoot
Messages: 20897
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 Dec 07 06:35:08 CST 2016

Total time taken to generate the page: 0.13498 seconds