Processing history changes on an update form

[John Fligg]

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

[Bruce]

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

[John Fligg]

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