>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.