Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing mystery ???
Message
From
09/02/1999 20:07:59
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00185510
Message ID:
00185767
Views:
19
Mark-

I must be missing something important, because in my universe I have to have a table used exclusively to create an index tag. I tried it as you list, and yes, indeed, when I try INDEX ON ... TAG expr I get the error "File must be opened exclusively."

So, how are you even getting to #4?

>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'.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform