Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Issues in taking IDX to CDX
Message
De
23/06/2014 05:44:10
 
 
À
20/06/2014 16:46:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01602158
Message ID:
01602211
Vues:
55
Look for any REINDEX commands
Look for switching of multiple IDX files



>I've inherited an application where most of the tables have IDX rather than CDX files. (First time I've seen IDXs in at least 15 years, maybe 20.) I know all the good reasons to change them. What I'm looking for are the traps I need to avoid if I do so.
>
>I can start the list:
>
>1) Need to change USE commands to eliminate INDEX clause
>2) Need to change SET INDEX to SET ORDER
>
>Anybody have experience with what else I'm likely to break if I do this? Not sure whether it matters, but the code in the app is in FoxPro 1 style (though I'm starting to introduce some new forms). Also, the app has SET COMPATIBLE ON.
>
>Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform