Thanks for the info... I'll look into this today.

Tommy

>>I'm about finished with a program written in VFP 6.0.
>>
>>It's purpose is to run at night (scheduled by NT4.0), to process data entered during the day.
>
>>There will not be anyone there to make human judgements about which data to accept if there are conflicts.
>>
>>Thanks!
>
>Tommy,
>
>When I do batch processing I have a results field in my "pending changes" tables. I then log either that it completed correctly or the error info. You can set TABLEUPDATE() to log the errors to an array. So if TABLEUPDATE()=.f., rollback the transaction and log the error and maybe oldval(), curval() and newval(). (Just make sure you TABLEUPDATE() your pending changes table with the error info outside of the transaction)
>
>HTH