Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a table while a table is shared
Message
 
To
05/03/1999 09:54:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00194459
Message ID:
00194462
Views:
26
David,
You can do INDEX ON expr TAG tag OF MyIndex.Idx
This creates a non-structural index. I recently found out that if you have a file with no structural .CDX file opened shared, that one user can create a structural tag (even though it's currently in use). However, when someone else attempts to open the table, they get an error because it now wants to open the CDX file as well (which is opened exclusively, because it was just created).
Watch out for that!
Mark

Actually, the preferred way of getting sorted data in a shared environment is to SELECT...ORDER BY... into a cursor.

HTH!
Mark

>Is a way to index a table while i have the table shared open
>
>thanks,
>
>dave
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Reply
Map
View

Click here to load this message in the networking platform