>All
>
>I know there is a way to insert a list of values into the IN() clause of a DBC View... but I can't seem to make it work.
>
>I've tried
>
>lcMyListOfVals=[val1','val2','val3]
>
>and
>
>lcMyListOfVals=[val1","val2","val3]
>
>but they don't work. I was fairly sure that the double quote version should work...
>
>Can someone please point me in the right direction?
>
>Thanks
>
>JR
...WHERE &?lcMyWhere
lcMyWhere = "myfield IN ('" + lcx + "', '" + lcx2 + ", ..... + ")"
Insanity: Doing the same thing over and over and expecting different results.