Mark, the code does indeed work without quotes around the viewname
or connection as shown below:
create sql view v_x remote connect lexnet AS select * from vendors
Any other things I need to be aware of while entering your world?
Guess I need to make sure I use a shared connection?
What about records to fetch and asynchronous execution?
>>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?
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