Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Do not understand INDEX ON
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement