>>>>>I have a VFP 8 application that runs the following query in 0.01 seconds. When I run it in VFP 9 SP1, it takes about 7 seconds:
>>>>>
>>>>>SELECT * ;
>Yes, I had this problem when VFP 9 first came out. Because of the bug to STR(), I postponed the upgrading of the program to VFP 9 until VFP 9 SP 1 came out. VFP 9 SP 1 fixed the STR() but not TRANSFORM() as you mentioned.
>
>I was hoping that there was a workaround so that I would not have to create a new index. Using SET ANSI is not a good solution for me, but at least STR() is fixed. I think IIF(lFtdAdversary, "Y", "N") will be a good substitute for TRANSFORM in my index.
>
>Thanks again for your help!
I think you found a bug and need to post it on MS site.
If it's not broken, fix it until it is.
My Blog