>When I try to pass a list to a parameter in a parameterized view it does not return any records.
>For example - my view contains "WHERE fieldname IN ?cListString"
>If I leave the parameter empty I can enter the string from the views prompt and the select works,
>however, if I supply the string to the parameter, it does not. I have tried single quotes, double quotes,
>parentheses, and every combination of the three I can conceive of. If you have had success with this
>problem without using macro substitution, I could sure use your advice. I only have the problem with the
>using lists.
>
>Thanks,
>Stan Harding
Stan,
Have you tried something like this;
lcListString = ["ABC","DEF","GHI"]