Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing mystery ???
Message
 
To
10/02/1999 11:17:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185510
Message ID:
00186513
Views:
29
Nancy,
If you're still interested, here is code which will re-create this effect. Notice that it is divided into segments, each to be run on a different session of VFP (2 VFP's loaded at once, on the same machine, defaulted to same path) in a certain sequence.

*- Run this segment on Session #1:
CREATE TABLE tblIndex FREE (cDummy C(10))
APPE BLAN
REPLACE cDummy WITH "Hello"
USE

SET EXCL OFF
USE tblIndex && Table is opened SHARED.

*- Now run this segment on Session #2:
SET EXCL OFF
USE tblIndex && Table is now opened twice.

*- Now run this segment on Session #1:
INDEX ON cDummy TAG cDummy && Creates tag even though opened shared & in use.

*- Now run this segment on Session #2:
BROWSE && This demonstrates that the table is still useable.
USE
USE tblIndex && Here's where you finally get an error.


Have fun!
Mark


>Hi, Mark-
>I'd sure like to see your actual code that produces this effect. I'd like to create a Fox2 format file and try it out.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform