Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell if record is locked by another user?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01107361
Message ID:
01107373
Views:
20
That gives me right result:
CREATE Table Test FREE (A1 N(5))
FOR asd = 1 TO 50
    INSERT INTO Test VALUES (asd)
NEXT

USE
***** Open new VFP Session and do:
USE Test SHARED
RLOCK()

*** Now back to the first session
SET REPROCESS TO 1
USE Test Shared
SET MULTILOCKS ON
FOR asd = 1 TO 50
    IF asd % 2 == 0
       RLOCK()
    ENDIF
NEXT
SELECT * FROM Test WHERE RLOCK()
*** The result is all records but first
*** Veery slow :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform