>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