Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When to use Transaction Processing and Table Buffering?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01150834
Message ID:
01150887
Views:
36
>Thanks for a very informative answer.
>If Table Buffering is locking the table (like FLOCK()), during TABLEUPDATE, does this mean that I cannot issue a TABLUPDATE if a second person is also using the table in a shared mode?
>Or does TABLEUPDATE try to lock each record to be updated one at a time like RLOCK() while performing the update?

Ah well, when updating you want something like:
If RLOCK()    && you now have the rec to yourself
  {do the necessary updating}
  llSuccess = TABLEUPDATE()
  UNLOCK
Endif
You need to ensure that YOU actually have a lock on a record before attempting the update.

You can be greedy and try to lock with FLOCK() but then no other user can access the table during the batch, and I don't think you want to do that.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform