Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where could be this index tag?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01541550
Message ID:
01541552
Views:
50
>Hi,
>
>I have a weird situation as following:
>
>A table belogs to a database. Table has fields MyField1, MyField2 (and a couple more). When I open this table in the Command Windows (and use Modify Structure) the table shows just one index, on MyField1. Yet when I issue command
>
>set index to tag MyIndex2
>
>
>I get no error. And it seems like the order of the table changes. Where could be the index tag on field MyIndex2 if I don't see it in the Modify Structure window?
>
>UPDATE. I noticed just now that the status line of the VFP IDE shows the following (as soon as I type SET INDEX TO TAG MyIndex1):
>
>Master index: MyTable.cdx Tag: MyField1
>
>That is even though I set the index tag to MyIndex2, VFP actually sets the index tag to MyIndex1.
>
>Could anybody explain this? TIA.

Use SET ORDER command, not SET INDEX. SET INDEX does something else.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform