Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing mystery ???
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Indexing mystery ???
Miscellaneous
Thread ID:
00185510
Message ID:
00185510
Views:
68
Heelo, All!
Can someone please explain these results:

1) Open two VFP 5.0 sessions on the same machine.
2) SET EXCLUSIVE OFF, on both.
3) USE MyTable (any FREE table), in both sessions (same table used).
4) In one session, do an INDEX ON Expr TAG Expr - no problem.
5) In the other session, table is still modifiable. Try SET ORDER TO Expr - error: 'Table has no index order set'. Close this table with USE and try to re-open - error: 'File access denied'.

It's like the table went from SHARED TO EXCLUSIVE use in the first session, because of the INDEX command!

All ideas will be appreciated!
TIA
Mark
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Next
Reply
Map
View

Click here to load this message in the networking platform