>I am using VFP 6 on NT 4 and connecting to an Oracle 8 database.
>
>This command works:
>
>create sql view "v_vendors" remote connect "lexnet" AS select * from vendors
>
>
>but trying to do the same thing from the view designer returns
>"No result set returned by the server". I am using a connection
>that otherwise works (see above). Any ideas why this is the case?
Welcome to my world. :( I was experiencing the same problem using the MS ODBC drivers (3 different versions) on an Oracle 7.3 db. However, I got the error programmatically and via the designer when trying to parameterize a date field. I never could figure this out. I worked around this form now by creating a remote view using a parameter on a different (character) field. Then I created a local view of the remote view using the date parameter. :( What happens if you do put quote marks arount the view name and the connection name? I do not think they are necessary. But since that works, I wonder why this fails in the designer because the SQL generated omits the quoe marks?
Mark McCasland
Midlothian, TX USA