Mariam
What is the error message?
>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
Previous
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