>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") >* failYep 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().