Using vfp 6.0.

Want to add an index to a shared network table. Put the following code in the app right before I display the table in a listbox:

index on upper(f_descrip) tag f_udescrip of qm_list ascending

I tested, my client tested, everything seemed to be fine. Now, 2 weeks later, I get a message that qm_list must be open exclusive to add an index. I have never opened qm_list exclusive but the message got me thinking (danger...danger).

Opened qm_list in the command window (not exclusive). Added the f_udescrip index (exactly like the statement above). Looked at the properties and f_udescrip was there. Closed qm_list. Opened qm_list. f_udescrip is not in the properties. Tried to "SET ORDER TO f_udescrip". Got a variable not found (also used several variations of the SET ORDER, none worked). Tried to add the f_udescrip index and got the message that it already exists. Now f_udescrip is in the properties list and I can SET ORDER TO.

1) Does "INDEX ON ... OF" add a permanent index to the CDX? If it does, why is my new index not in the properties list box until I try to add it again?

thanks - brenda