Information générale
Titre:
View behaviour in VFP7 vs VFP9
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
In VFP9, if I USE each table prior to the view, it works - e.g.
USE company_list IN 0
USE division_list IN 0
USE department_list IN 0
USE location_list IN 0
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