You're right. Is as simple as typing it like that.
Well, I guess I got more confused in this instance, thinking about something I wanted to do couple of weeks similar to this.
I had in one table values like:
1
2
3
4....and so on
I wanted to read wherever mixed numbers where coming into the WHERE IN.
Since there where coming from a table if I put them into an array it would not work in the IN(...) and I did not want to type it up like we are doing here.
So the how would you do that? I mean, read it in a 'linear' format instead of columnar.
Does this makes sense or am I confusing you too?
Thanks for answering Gavin
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...
>>>How do I do this?