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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only