When I change a record, I find two entries in the Audit log, why?

Top  Previous  Next

Every time I change a record on an audited table I get two records added to the Audit trail - a READ and a CHANGE. Is the read actually necessary? It seems redundant...

 

This is how it is designed. The first record has the ORIGINAL information, and the second record has the NEW information. Both are necessary to show what fields changed in the "change" operation.

Actually, comparing the original information with the previous record of the same file is a good way to detect external manipulation of the file. If everything is ok they should be equal.