Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record Not Locked Error?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Record Not Locked Error?
Divers
Thread ID:
00762568
Message ID:
00762568
Vues:
50
Create Cursor seeme ( cUser c(40) )
Insert into seeme( cUser ) values ( "a") 
Insert into seeme( cUser ) values ( "b") 
Insert into seeme( cUser ) values ( "c") 
Update UserTable Set iDel=1 Where Lower(cUserId) == ( Select Lower(cUser) from seeme )
That ends with an error "Record is not locked".

This is all within the VFP8 command window. My Data Settings are
[x] Automatic File Locking
[x] Multiple Record Locks
Buffering - Off
Reprocessing - Attempt Lock (Default)
because I think these are the default settings when the data is touched via the OLEDB driver.

That did I miss?

Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform