Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compound or structural indexes?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Compound or structural indexes?
Divers
Thread ID:
00130281
Message ID:
00130281
Vues:
51
I am trying to use a compound or structural index for the very
first time. Here is my question:

What goes in the SET ORDER TO TAG _ _ _ _ ?

I prepared these fields in the DB Designer and
I have DB fields with indexes as follows:

Field1 with an Index of Field1 and an Expression of Field1+Field2
Field2 with an Index of Field2 and an Expression of Field2

How do you refer to the Field1+Field2 in the SET ORDER TO TAG command?

Can I refer to just the Field1 part of the Field1 index or what?

I have like ID numbers in Field1 and I have Part numbers in Field2,
but the ID numbers in Field1 are not unique so that makes this a
little tricky to me. Because I want to step through all records
for each ID and Part Number combination when I'm doing Top,
Bottom, Prev, Next. So far it's been skipping the duplicate ID
records and not showing me the other records with like IDs.

Any help would be appreciated. THanks so much.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform