>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?
>
>Just starting to do some digging
>
>Thanks in advance
Kelly,
VFP changed some of the ways it handles local and SQL Server tables.
Try using the SETENGINEBEHAVIOR to the previous version you were using. Either 70 or 80.
George
Ubi caritas et amor, deus ibi est