NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: John Fligg on October 01, 2012, 06:17:32 AM

Title: Processing history changes on an update form
Post by: John Fligg on October 01, 2012, 06:17:32 AM

I am trying to create an audit log of changes made to a record when closing a form. In traditional Clarion this is done in ThisWindow.TakeCompleted before the Parent Call.

Where would I put my code in NetTalk to achieve the same thing. IOW the point at whch the form is actually closed for good.

Many thanks

John

Title: Re: Processing history changes on an update form
Post by: Bruce on October 01, 2012, 10:34:29 PM

The form procedure is called many times, so as a procedure it "closes for good" many times as well.

For auditing, it would depend a lot on how you plan to audit. The ValidateRecord routine contains the record primed for saving (but not yet save). The PostUdate / PostInsert etc contain the record after being saved.

If you wanted to "cache" a copy of the record when the form opens, I'd likely do that in the PreUpdate routine.

cheers
Bruce

Title: Re: Processing history changes on an update form
Post by: John Fligg on October 01, 2012, 10:47:59 PM

Thanks Bruce.

You probably second guessed I will be using HISTORY: at the start and then comparing after insert/update so this sounds perfect.

Still difficult to stop thinking in "traditional" Clarion terms and switch over to the transaction type processing.

Many thanks

John