Found it.
The problem was the order of the clauses in the SQL SELECT statement.
The ORDER clause must be last (after the WHERE clause).
I changed the order of the clauses and it worked.

Thanks to all for your help.




>Hi everyone,
>
>I'm having a problem creating a remote view.
>I have 3 tables as follows:
>events -> eventid, eventname, eventdate
>companies -> companyid, companyname, etc...
>eventsattendance -> eventid, companyid
>
>The table "events" holds the description of the events, shows, etc...
>The table "companies" holds companies information
>The table "eventsattendance" holds which companies went to which events
>
>From those tables I need to produce a view with all the companies who attended a particular event. This is the code:
> CREATE VIEW eventcompanies REMOTE CONN 'sql server' AS ;
> SELECT eventattendance.companyid, eventattendance.eventid, ;
> events.actdate, events.actname, companies.companyname FROM eventattendance ;
> LEFT OUTER JOIN events ON eventsattendance.actid = events.actid ;
> LEFT OUTER JOIN companies ON eventsattendance.companyid = companies.fullid ;
> ORDER BY eventsattendance.actid, company_name ;
> WHERE eventsattendance.actid = ?gnEventChosen
>
>The message it gives is:
> Program Error: No result set has been returned by the server.
>
>If I execute the select query alone, after assigning a value to gnEventChosen, it succeeds. If I change the WHERE clause and use a static parameter (WHERE eventsattendance.actid = 1) it succeeds.
>
>So obviously the problem is the parameter.
>
>Thanks in advance for your help.