Hi Edgar,
How about:
cParList = "('A','B','C','D')"
DO MyProg WITH cParList
PROCEDURE MyProg
LPARAMETERS pcParList
SELECT * ;
FROM mytable ;
WHERE myfield ;
IN &pcParList ;
INTO CURSOR mycursor
Hope this helps,
Gavin...
>I got stuck with probably simple stuff, but this is the deal:
>I want to pass a parameter to my WHERE IN clause.
>What is passed will be a series of string like ‘A’,’B’,’C’,’D’
>or it could be ‘A’,’D’ (don't know how many are passed)
>So It will go like this
>
>DO myProg WITH cParList
>
>How do I do this?