W
Walter
I've created an InfoPath 2003 form that has three drop-down controls that are
populated from SharePoint V2 lists... two of the three work successfully, but
the third one throws the following error.
The following DataObject either cannot be created or cannot be initialized:
Scheduled Courses
The query cannot be run for the following DataObject: Scheduled Courses
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:
Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was
thrown.
<detail><errorstring
xmlns="http://schemas.microsoft.com/sharepoint/soap/">The ORDER BY clause is
invalid in views, inline functions, derived tables, subqueries, and common
table expressions, unless TOP or FOR XML is also specified.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'with'. If this statement is a common
table expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon.</errorstring></detail>
I'm not sure about the ORDER BY clause reference, two of the lists have
views with SORT values specified but none of them use GROUPS... so I'm kind
of at a loss. Any assistance would be of value.
Thanks
populated from SharePoint V2 lists... two of the three work successfully, but
the third one throws the following error.
The following DataObject either cannot be created or cannot be initialized:
Scheduled Courses
The query cannot be run for the following DataObject: Scheduled Courses
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:
Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was
thrown.
<detail><errorstring
xmlns="http://schemas.microsoft.com/sharepoint/soap/">The ORDER BY clause is
invalid in views, inline functions, derived tables, subqueries, and common
table expressions, unless TOP or FOR XML is also specified.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'with'. If this statement is a common
table expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon.</errorstring></detail>
I'm not sure about the ORDER BY clause reference, two of the lists have
views with SORT values specified but none of them use GROUPS... so I'm kind
of at a loss. Any assistance would be of value.
Thanks