>Gunnar,
>
>I ran the test in VFP8SP1 last night, I didn't test any other versions. I can try it in VFP6 and 7 tonight. This may be an improvement that has been made to the SQL engine between versions. It does sound like you have an acceptable solution now though, so this is just a justification to move to 8 right? *bg*


Absolutley! <s>
it would be nice if you could test it in Vfp6 Sp5. Thanks.

>
>>Thanks for creating a test. I just ran your test (copied and paste) on my machine, and i get the same error as with my large sql. did you do that with vfp 6 SP 5 (i don't know if i mentioned that earlier)? sure is strange. In any case, i just create a 'pre-querry' which combines all 9 fields to 1 and the run the actual sql against the cursor instead the original table. it add 1 second to the report generation, but that's acepable, i think.