PRB: Parameterized View Discrepancy Using IN() Filter Criteria

MORE INFORMATION

Steps to Reproduce Behavior

1. Issue the following command in the Command window:

   MODIFY DATABASE HOME()+"samples\tastrade\data\tastrade.dbc"
   						

2. Create a New Local View using the View Designer.
3. Add the table "Customer" to the View.
4. Select all fields for output.
5. In the filter section, enter "customer.customer_id" as the "Field Name," select "IN" as the Criteria, and enter "?lcKeyList" as the Example.
6. When you select the View SQL option, you should see the following:

         SELECT *;
          FROM tastrade!customer;
          WHERE Customer.customer_id IN (?lcKeyList)
   						

7. Save the view and close the View Designer.
8. In the Command window, execute:

   lcKeyList=' "ALFKI,","ANATR,","ANTON" '
   						

9. Open and then Browse the View.
10. Note that you get an empty cursor. Close the Browse window. Close the view using the USE command.
11. Again, in the Command window, release lcKeyList by executing the following:

    CLEAR MEMO lcKeyList ALL
    						

12. Open and then Browse the View.
13. When asked for the value for lcKeyList, enter the following exactly as follows:

    "ALFKI",ANATR","ANTON"

14. Note that you get a single record. Close the Browse window. Close the view with the USE command.
15. In the Command window, execute the following:

    lcKeyList=' "ALFKI","ANATR","ANTON" '
    						

16. In the Command window, execute the following:

          SELECT * FROM tastrade!customer
           WHERE customer_id IN (&lcKeyList)
    						

17. Note that a cursor with three records is returned.