Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to index a tmp file ?
Message
 
To
18/01/2002 01:47:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00606566
Message ID:
00606589
Views:
29
You only need to open the file exclusively if you are creating a Compound index (For Eg INDEX ON FieldName TAG MyTag)
However if you are creating an IDX index you can index it while it is shared. For example INDEX ON FieldName TO MyTmpIdx.
The Temporary Index File MyTmpIdx however cannot be opened my a second user.
On hte other hand if you want several users to share the same Index file it must be a Compound (CDX) index and this gets updated automatically when data changes. Also, you need to open the file only once EXCLUSIVELY during development to create the CDX file. After that you can open it in a shared mode and the CDX file will get updated automatically.
Previous
Reply
Map
View

Click here to load this message in the networking platform