Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compound or structural indexes?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Compound or structural indexes?
Miscellaneous
Thread ID:
00130281
Message ID:
00130281
Views:
54
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.
Next
Reply
Map
View

Click here to load this message in the networking platform