*!* * Problem: Always extracts all records even though This.Value is not empty *!* * and LEN(This.value) = LEN(Orders.cust_ID) *!* * Form displays error: THIS can only be used within a method SET EXACT OFF SET ANSI OFF SELECT order_id,order_date, order_amt, shipped_on FROM orders ; WHERE orders.cust_id = This.value ; INTO CURSOR curSelectedOrders ; ORDER BY order_id * This works *!* SET EXACT OFF *!* SET ANSI OFF *!* SELECT order_id,order_date, order_amt, shipped_on FROM orders ; *!* INNER JOIN customer ON orders.cust_ID = customer.cust_ID ; *!* WHERE orders.cust_id = This.value ; *!* INTO CURSOR curSelectedOrders ; *!* ORDER BY order_id * This also works ... *!* SET EXACT ON *!* SET ANSI OFF *!* SELECT order_id,order_date, order_amt, shipped_on FROM orders ; *!* WHERE orders.cust_id = This.value ; *!* INTO CURSOR curSelectedOrders ; *!* ORDER BY order_id && Extracts correct records * This also works *!* SET EXACT OFF *!* SET ANSI OFF *!* SELECT order_id,order_date, order_amt, shipped_on FROM orders ; *!* WHERE orders.cust_id == This.value ; *!* INTO CURSOR curSelectedOrders ; *!* ORDER BY order_id && Extracts correct records * This also works *!* SET EXACT OFF *!* SET ANSI ON *!* SELECT order_id,order_date, order_amt, shipped_on FROM orders ; *!* WHERE orders.cust_id = This.value ; *!* INTO CURSOR curSelectedOrders ; *!* ORDER BY order_id && Extracts correct recordsI looked at the help of SET EXACT and SET ANSI, but could not understand the reason for SELECT retruning all records, particularly the form displaying error.