>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement