Walter,

Can you provide complete repro code?

>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.