>>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"]

I had not actually tried brackets, but I have now and no records
were returned. I think it would be the same as this which I had
tried:
lcListString = '"ABC","DEF","GHI"'

Also, I was wrong about getting correct results from the prompt
when list string variable is not supplied. Only hits from the
first string in a hand entered list are returned. I guess I'm
going to have to resort to go ole macro substitution.

By the way, I really enjoyed your sesson this year on
frameworks. I'm building my own now.

Thanks for the inspiration.

Stan