Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing mystery ???
Message
From
10/02/1999 18:31:50
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185510
Message ID:
00186288
Views:
18
>Hi Craig,
>
>The table is on a local drive.
>
>Mark
>
>>>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
>>
>>Is the table on your local drive or the network?

That explains it. Because it is local, VFP assumes that no one else will need access to the table and will allow you to do this.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform