>I have a system about to go live, and just discovered a bug caused by the transition from VFP6 to VFP9. I've created a short piece of code that shows the problem:
>
>OPEN DATABASE ....
>CREATE SQL VIEW xview ;
> AS select * from company_list ;
> union select * from division_list ;
> union select * from department_list ;
> union select * from location_list
>USE cddl2
>BROWSE
>
>In VFP9 I get an empty browse, in VFP7 it displays correct results
>

Maybe it's just a typo, but right before the Browse, you're using some other table, not the view you just defined.

Tamar