Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does this TABLEUPDATE() fail?
Message
From
21/09/2005 07:34:25
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01051485
Message ID:
01051579
Views:
8
Thanks. It was surprising.

Alex

>I see that you found answer already. You can replace
DELETE FOR ...
>* With
>SCAN FOR ...
>  DELETE
>ENDSCAN
>
>>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform