Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reprocess & Record Locking
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00581102
Message ID:
00581111
Views:
19
>Hi All,
>
>Any suggested value for SET REPROCESS?
>
>TIA
>
>Robert

Since I use optimistic buffering or SPT, SET REPROCESS is nearly irrelevant. User competition for the same record is usually minimal when trying to edit a Customer record for example. Again, since I am not editing the data directly in a table, reprocess is basically irrelevent because a TableUpdate() or SPT to do the update will lock the record for a fraction of a second. I do not need reprocess because I can put this updating in a loop until the return value is true or greater than zero. I can also limit this to so many tries using a counter of delay the next attempt by using INKEY().

If you really need it, I would not set it longer than 2 seconds or a few attempts.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform