Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why these two commands will give different results
Message
 
 
To
05/12/2006 08:19:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174441
Message ID:
01174891
Views:
9
>Naomi,
>
>>Are you suggesting to keep existing indexes and add structural indexes as well?
>
>yes, exactly. Add the structural indexes, and change the code itself when you have the time. Since the structural indexes are automatically "conencted" and updated, you don't have to do anything else to make SQL commands use them. The only thing you must be careful with, is the names of the index tags. I don't know what will happen if an index tag has the same name name as an index file, but it's better to be safe than sorry.
>
>I did a similar convertion many years ago myself, and I was also very reluctant. But the process was absolutely painless, and after that I never use IDX indexes anymore.
>

Thanks, I'll try first on our test data.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform