>>>View parameters want to be single values. For the view you are trying to create try it his way;
>>>
>>>
>>>cListCities = THISORM.cCities
>>>SELECT *;
>>> FROM geo!homechk;
>>> WHERE ALLTRIM(Homechk.city) IN (&cListCities);
>>> ORDER BY Homechk.city, Homechk.lastname, Homechk.firstname
>>>
>>
>>Jim,
>>
>>Does this mean I have to create the view in the Init of the form instead of the view designer or should the & be a ? ?
>
>Bruce,
>
>You canc reate it in the view desinger, I think. The ambersand is an ambersand not a question mark. It does a macro expansion of the memory variable.
OK - couple of points.
1-cannot create it in the designer as it puts quote marks around anything that doesn't begin with a question mark.
2 - Created it in the INIT of the form and tried with a plain variable as well as preceeding it with an ampersand and then a question mark. Works even worse than before even if I make it public. Before it at least evaluated the first city on the list and displayed those results. This time it didn't even do that.
I'm stumped. It looks as though I have found a situation where a parameterized view does not work and I have to use a FILTER (which by the way I was doing before and it worked fine)
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein