Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Issues in taking IDX to CDX
Message
From
23/06/2014 05:44:10
 
 
To
20/06/2014 16:46:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01602158
Message ID:
01602211
Views:
54
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
Previous
Reply
Map
View

Click here to load this message in the networking platform