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