NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on March 31, 2010, 04:51:25 AM

Title: Getiing a history of record changes
Post by: terryd on March 31, 2010, 04:51:25 AM

I need to hold a record of all changes to fields in certain of my tables. Has anyone got a method?
Something like logflash, fullrecord or even the dbaudit procedure in Clarion.
If not which embed would I use to store the original values and which embed would I use to check the changes and write them to the change record table.
e.g.
Someone changes field DEBIT AMOUNT from 25.00 to 35.00
I need to be able to write to a change record table changed by, date, time, changed field DEBIT AMOUNT from 25.00 to 35.00.
Thanks for any help you can give.

Title: Re: Getiing a history of record changes
Post by: kevin plummer on March 31, 2010, 05:17:50 AM

Pre-Update will give you the initial record. Validate will give you the final record where you could determine what changed. The trick is you would need to store the pre-update record n the session Q or somewhere as the validate runs on a separate thread.

This would work on a simple form. EIP Browse may be a bit trickier.

Kev

Title: Re: Getiing a history of record changes
Post by: terryd on April 01, 2010, 08:30:57 AM

Thanks Kevin