Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to index results of query
Message
 
To
23/02/1998 18:41:37
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00079892
Message ID:
00080670
Views:
41
>An older trick is to
>USE DBF('mytable') AGAIN...
>index on whatever tag whatevername OF (tmpcdxname)
>
>...where tmpcdxname is any random filename, I usually compose it using _work+sys(3), and _work is usually "C:\scratch\". By using a separate .cdx file, we don't try to create a structural index, and it doesn't have to touch the 29th (or was it 28th) byte of the table header.

Dragan, this still indexes the original file, which means it has to be used Exclusive. By using it as a cursor with NOFILTER (or, in VFP3 with an additional field) means it's already used Excl. and is on your hard disk - much easier to index.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform