Kevin,

Just a reminder that betas usually contain tracking/debugging code. Since it is clear that SQL has been changed significantly in VFP8, I suspect that such stuff may be at play here.

That said, I see you are using FP 2.6 tables. It may be an idea to open a "Bug?..." thread here if only to ensure that such tables are considered by a wide (official) beta population.

In some other thread Sergey mentioned something like "SET DATAENGINE TO 70". You might search for the exact name and then try that.

cheers


>Well, this app was developed in v6.0 and ran fine then, I'm now testing the same project using VFP8 beta to see how it copes.
>
>Kev
>
>>Kevin,
>>
>>I'm still not sure if you consider it a problem in VFP8beta or with query itself. Did you try to run it under VFP6 or whatever VFP version you're using?
>>
>>>I haven't got version 7, we are bypassing it.
>>>
>>>I don't think it is the UNION now, I'm having a similar experience with another select (contains joins).
>>>
>>>It seems to be when I run selects from Fox for dos tables and JOIN them with VFP tables.
>>>
>>>Kev
>>>