Remote view is a cursor. So usually you need to:

open data....
use (remote_view)
select * from (remote_view)

>I have a remote view. When I issue:
>
>

>select * from remoteview into cursor test
>

>
>I get an open dialog box listing tables in database. If I issue same command in local view it works fine. Why can't I retrieve data using select command for remote views? How can I get data from remote view into a cursor?
>
> thanks
>Nick Patel