>We recently did a test run for converting our 8 sp1 application to 9 and have run into some issues. When certain queries are ran the execution time goes from 15-20 seconds to 10 minutes! After walking through some of the code I have noticed that part of the query is not working properly, in 9 only! The exact same query works just fine in 8. They are being ran off of the same data as well. The coding is for a quasi multidetail line report but it is not limited to this select statment. Basically the test code took the contents from two cursors and inserted them into one cursor for reporting. The probelm occurs when the second curusor is loaded, it loads all the recrods instead of the single record needed. Is there a program setting that I am missing here (tried the report behavior one - no luck) or something?
>

Sounds like a single-table query went from being partially optimized to fully optimized, so VFP is now filtering the original table, which is giving you the results you see.

Try testing with SYS(3054).

Tamar