General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Issues in taking IDX to CDX
Environment versions
Network:
Windows 2008 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only