Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why does this TABLEUPDATE() fail?
Message
 
 
À
20/09/2005 18:35:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01051485
Message ID:
01051521
Vues:
15
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform