Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there another way to index a table?
Message
From
21/05/1999 07:44:45
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
21/05/1999 07:27:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00221286
Message ID:
00221290
Views:
12
>Is there another way to index a table with
>using INDEX ON my_fld TO inx_name?
>
>I want to ORDER BY a group of records
>that are contained in a filter using SET FILTER TO something.
>I do not want to use INDEX TO or the SELECT statement.
>Any ideas?

What are you trying to acheive with the index? To optimize the filter, or to order the records?

If you want to order records by a number of fields, simply add them together in the index :-

INDEX ON Field1+Field2+Field3 TAG tagname
(Remember to convert numbers and dates to character values).

If you want to optimise the query, then create a seperate index tag for each field and Rushmore will do the rest.
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform