Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with IDX and setting order
Message
 
 
À
06/02/2008 13:39:42
Mike Sue-Ping
Cambridge, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01290080
Message ID:
01290348
Vues:
14
This message has been marked as the solution to the initial question of the thread.
Mike,

If you run ATAGINFFO() and examine the first column (Tag/Index name), you'll see that for IDX file it's IDX file name (w/o) extension. That's what you should use in the SET ORDER TO command.
SET ORDER TO (JUSTSTEM(m.lcIDXName))
>
>I have no spaces in the path. In fact, if I set m.lcIDXName = "c:\_Temp" it still causes the error.
>
>Interestingly enough, if I use use SET INDEX TO... I can set the fullpath to the IDX file and not cause the error. The bad news is that my grid does not switch it's ascending/descending order when I SET ORDER TO...
>
>So to make this work for me, I need to set m.lcIDXName = "somevalidfilename" and not include the path. I've tried the other commands like SET INDEX TO... then SET ORDER TO... and they all generate the same error if I specify the fullpath to the idx file. Weird.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform