General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only