Getiing a history of record changes

[terryd]

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.

[kevin plummer]

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

[terryd]

Thanks Kevin