The problem I was having was strange and abnormal. No tinkering with the share clause, asych or fetch resolved the problem. I was only able to create the view if I left off the
Begin_Date > ?lnBgnDate part of the where clause.
>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?
Mark McCasland
Midlothian, TX USA