Geoff,
I see the same. I think this's a bug in VFP8.
>This piece of code generates a 'SELECTs are not UNION compatible. Fields DESCR and DESCR are incompatible' error using VFP8 beta when it runs the query against a Fox2.6 table.
>
>This is not a problem in VFP7 or previously.
>
>
>CLOSE data
>CREATE TABLE temp;
> (job n(6), descr M)
>
>FOR count=1 TO 500
> INSERT INTO temp (job, descr);
> value (0, 'Whatever')
> ENDFOR
>
>COPY TO temp2x TYPE fox2x
>
>* no problem here-using a VFP 8-type table
>SELECT descr from temp;
> where job=13226;
> union all;
> select descr from temp;
> where job=13226;
> into cursor tempw1
>
>* problem here when using the Fox2x-type table
>SELECT descr from temp2x;
> where job=13226;
> union all;
> select descr from temp2x;
> where job=13226;
> into cursor tempw2
--sb--