>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