Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there another way to index a table?
Message
De
21/05/1999 07:44:45
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, Royaume Uni
 
 
À
21/05/1999 07:27:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00221286
Message ID:
00221290
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform