>>>Hi everybody,
>>>
>>>Does someone has a code snippet ready to get all changed fields from GetFldState + what the difference is (original value / new value). Just looking for already written code, I guess.
>>>
>>>Thanks.
>>
>>UT Magazine, May 2003, A Basic Audit Trail
>
>Ok, I'll take it as a basis for the method.
>
>The other question is - is there a way to trigger that code only if I have ASSERT here ?
For the audit trail in Bata/Bolivia, we had code similar to the one in the article, called from a table trigger function like _audit("D"), _audit("I") or _audit("U") (for the three cases, "delete", "insert", "update"), attached to each table in the database.
Eventually we saw the need to omit recording audit information under certain circumstances; we did this through some variable, which was checked in the audit trail functions.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)