Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() again.
Message
From
25/11/2002 21:01:42
 
 
To
25/11/2002 17:10:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00726694
Message ID:
00726779
Views:
10
Hi Mark,

I will expect someone to correct me. The answer is yes and no. If you have an error handler and you try to =tableupdate(), and then an error is encountered, the error handler will process the reported error from the =tableupdate(). If you do not code your error handler to except the error, the process will stop there. If you do tell the error handler to go ahead and retry - then you will in effect set your reprocess to AUTOMATIC.

I strongly recommend you use transaction processing to work around this error if you expect difficulty. Also, I would insist on buffering to avoid complete locking of a file.


HTH

Ric

>When Fox executes tableupdate() and command fails trying to isert a new record because the header being locked does it use reprocess setting to do tableupdate() more then once?
>
>Thanks, Mark
Previous
Reply
Map
View

Click here to load this message in the networking platform