Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: SQL: Error correlating fields.
Message
De
01/04/2005 02:39:21
Walter Meester
HoogkarspelPays-Bas
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
BUG: SQL: Error correlating fields.
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01000538
Message ID:
01000538
Vues:
125
VFP9 the error when executing the command below:
SELECT trm_acu_id as Acu_id, trm_cycleno as Cycleno,  trm_partner as Partner, Trm_ovumdonor as Ovumdonor, ;
	trm_semdonor as semdonor,  trm_ovumcycle as Ovumcycle ;
	FROM t_Treatmen Tr  ;
		WHERE ( EXISTS (SELECT Prn_acu_id AS Acu_id FROM t_prognotes T,  t_progdets  ;
			WHERE Prn_acu_id = Tr.Trm_acu_id AND prn_enc_cycle = tr.trm_cycleno AND Prd_Numvalue >  200 AND ;
				prd_mdsfk =      70105 AND  prn_enc_id = prd_enc_id) OR ;
		EXISTS(SELECT Prn_acu_id AS Acu_id FROM t_prognotes T,  t_progdets ;
			WHERE prn_acu_id = tr.trm_acu_id AND prn_enc_id = prd_enc_id AND  prn_enc_cycle=SPACE(10) ;
				AND Prd_Numvalue >  200 AND prd_mdsfk =      70105  ))
This command runs without any problem in VFP8. The error occurs regardless of SET ENGINEBEHAVIOR.
Interestingly when I change the OR operator between the two EXISTS into AND, it runs without a problem

A real showstopper in my app as these kind of SQL occur frequently.

Walter,
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform