Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow SQL queries in VFP9
Message
From
24/02/2006 11:31:24
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01098650
Message ID:
01098932
Views:
17
>>Yes I totally agree, but the issue is not about what are the best coding pratices but why it runs fine in earlier versions and not in VFP9. Remember that these are legacy apps and it is not my client's intention to upgrade the much of the underlying code.
>>
>Hi Joe,
>
>The handling of indexes has been changed in VFP9 to avoid situation where code seems to be working but my produce incorrect result in some circumstances. Check new section Considerations for Creating Index Expressions in VFP9 help for more details.

Thanks Sergey,

That makes sense.

Joe
Previous
Reply
Map
View

Click here to load this message in the networking platform