Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record Not Locked Error?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Record Not Locked Error?
Miscellaneous
Thread ID:
00762568
Message ID:
00762568
Views:
51
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.
Next
Reply
Map
View

Click here to load this message in the networking platform