hello !
probably my question is too easy , but i'm completely confused with the syntax.
First, i run sql statement in SQL Query Analazer
select * from mytable where ctype in ('M','B','D') - works fine.
Second, i create remote view in VFP 8
CREATE SQL VIEW "RV_MYVIEW";
REMOTE CONNECT "SQL7" AS ;
SELECT * ;
FROM mytable ;
WHERE ctype IN ( ?pk_type ) browse in DBC works fine
Third, in Init method i write
pk_type="'M','B','D'"
REQUERY('RV_MYVIEW') - it doesn't work.
The same syntax i used for local views with VFP6 - everything worked fine.
May be somebody can help me with this ?
Thanks a lot, Mariam
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