>Others invariant forms:
>

>CREATE CURSOR orders (ord_pk I, ord_dummy C(10))
>CREATE CURSOR Orderlines (orl_pk I, orl_ordfk I, orl_itmfk I)
>CREATE CURSOR Items (itm_pk I, itm_name C(10))
>* fail
>SELECT * FROM orders O ;
>	WHERE EXISTS(SELECT 1 FROM orderlines INNER JOIN Items ON orl_itmfk = itm_pk ;
>		WHERE orl_ordfk = O.ord_pk AND itm_name = "BIKE") OR ;
>	EXISTS(SELECT 1 FROM orderlines INNER JOIN Items ON orl_itmfk = itm_pk ;
>		WHERE orl_ordfk = O.ord_pk AND itm_name = "SCOOTER")
>* fail

Yep this is the bug

>SELECT * FROM orders O ;
>	WHERE EXISTS(SELECT * FROM orderlines INNER JOIN Items ON orl_itmfk = itm_pk ;
>		WHERE orl_ordfk =O.ord_pk  AND itm_name = "BIKE" OR orl_ordfk = O.ord_pk AND itm_name = "SCOOTER")

This also fails in VFP8 because of the OR in the EXISTS().


Walter,