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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement