General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only