Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering, Transactions, non-human intervention
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00519062
Message ID:
00519256
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform