Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does this TABLEUPDATE() fail?
Message
From
20/09/2005 18:35:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Why does this TABLEUPDATE() fail?
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01051485
Message ID:
01051485
Views:
45
Found the answer:

Commands that Automatically Lock Records and Tables
DELETE of more than one record Entire table

Thank you.

Alex
*-----------------
I was surprised by this behavior:

A table has buffering = 5.

In session one, one record is locked while editing (to prevent another user from editing same).

In session two, user deletes a different record with DELETE FOR cField = lcValue. Pointer goes to EOF(). At that moment I issue TABLEUPDATE(.T.,.T.) but it returns .F. indicating failure. The problem does not ocurr if session one did not have lock in its record.

The problem also doesn't occur if I say:
LOCATE FOR cField = lcValue && Actually there was only one record in this case
DELETE
TABLEUPDATE(0,.T.)

Question is why did the tableupdate fail?

TIA,

Alex
Next
Reply
Map
View

Click here to load this message in the networking platform