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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement