Hi Borislav.


Thanks for your reply... I'll have alook at the Triggers.
Is there a way of looking at the calling stack at the trigger point.
ie.e I need to be able to see whcih Screen or prg (and Hierarchy) at the point of the update.

Regards,
Gerard


>>Hi. I have been chasing a problem with a database change, that
>> I cannot find the source of... looks like a field is being updated incorrectly. (it only happens once every 1500 updates) I've put audit trails in to the app where I think its going wrong, but still cant get to the bottom of it.
>>The App has about 150 forms adn this partciular table could be updated from quite a number of the forms.
>>
>>Is there a way of tracking table changes , preferably at the Database level, so I dont have to go into each form. My updates can be from Append, Replace with , Inserts and Updates .
>>
>>If there was a trigger , where I could update a Log file with:
>>Date, Time, Field Value and most importantly Calling Form or Prg
>>
>>Anybody know if this can be done ?
>>Regards,
>>Gerard
>
>Put TRIGGERS in every table you want to trace FOR UPDATE, DELETE and INSERT.