>SELECT * ;
>FROM mytable ;
>WHERE ctype IN 'M','B','D'
>****
>sorry , i got you confused, but
>let me put my question in that way:
>
>How to create and populate remote parameterized view that requires lists of parameters ?
>****
>Actually i found the one way, it's not the best thing in the word, but it works
>
>CREATE SQL VIEW My_view;
>REMOTE CONNECTION sql_conn1;
>As select * from my_table ;
>where my_table.type =?ctype OR my_table.type =?ctype1
>**********************************************************
>
>As i said before i worked with parameterized local views :
>
>Create SQL View lv_view AS
>Select * from my_table;
>where Inlist(my_table.ctype, ?&ctype)
>
>ctype=" 'A', 'B', 'C' "
>requery('lv_view')
>
>but it doesn't work with SQL SERVER.
>
>thank you, sorry for bothering you
SQL SERVER would require that there be parenthesis around your list:
SELECT * ;
FROM mytable ;
WHERE ctype IN
('M','B','D'
)