General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
I'm not sure that this will work, never having tried this, but
try placing the ? inside the parenthesis.
HTH
Dan
Previous
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