Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does this TABLEUPDATE() fail?
Message
 
 
To
20/09/2005 18:35:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01051485
Message ID:
01051521
Views:
9
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?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform