Hi Brenda!
You do not need the 'OF' clause if you want a permanent, structural tag.
Mark
>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
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.