General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Passing a parameter to th IN clause
Hi All,
Using VFP 6.0 I can pass dates as per below but how to pass items to the IN clause? Any help will be appreciated.
lcProdCds = "'F', 'G', 'H'"
WORKS:
and Actual_Office_Cplt_Dt > ldBegPer;
and Actual_Office_Cplt_Dt < ldEndPer;
AND SUBSTR(vOFF_DOC.PROD_CAT_CD,1,1) IN ("'F', 'G', 'H'");
DOES NOT WORK:
and Actual_Office_Cplt_Dt > ldBegPer;
and Actual_Office_Cplt_Dt < ldEndPer;
AND SUBSTR(vOFF_DOC.PROD_CAT_CD,1,1) IN ?(lcProdCds);
TIA.
Regards,
Paige
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only