3.1.4.10 OpenResultSet

This operation opens a result set for the given source and returns a subset of rows from the result set.

The following is the WSDL port type specification of the OpenResultSet WSDL operation.

 <wsdl:operation name="OpenResultSet" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Access/Server/WebServices/AccessServerInternalService/AccessServiceSoap/OpenResultSet" message="tns:AccessServiceSoap_OpenResultSet_InputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:output wsaw:Action="http://schemas.microsoft.com/office/Access/Server/WebServices/AccessServerInternalService/AccessServiceSoap/OpenResultSetResponse" message="tns:AccessServiceSoap_OpenResultSet_OutputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:fault wsaw:Action="http://schemas.microsoft.com/office/Access/Server/WebServices/AccessServerInternalService/AccessServiceSoap/OpenResultSetAccessServerMessageFault" name="AccessServerMessageFault" message="tns:AccessServiceSoap_OpenResultSet_AccessServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

The protocol client sends an AccessServiceSoap_OpenResultSet_InputMessage request message and the protocol server responds with an AccessServiceSoap_OpenResultSet_OutputMessage response message as follows:

  • The protocol server retrieves data from the content database using the given source and restriction.

  • The protocol server stores the data in a result set identified by the moniker within the session identified by the WorkbookId element of the parameter element in the request message. The protocol server also stores expressions defined by sortExpression, filterExpression, and aggregateExpressions elements in the result set.

  • The protocol server returns a subset of rows specified by startRowIndex and maximumRows as follows:

    • If the maximumRows element is set to zero ("0"), the protocol server returns all visible rows from the result set starting with zero, overriding the value specified in startRowIndex.

    • If the maximumRows element is greater than zero and startRowIndex + maximumRows exceeds the number of visible rows in the result set, the protocol server returns all visible rows in the result set with indices greater than or equal to startRowIndex.

    • Otherwise, the protocol server returns all visible rows from the result set with indices starting at startRowIndex and ending at startRowIndex + maximumRows - 1.

  • The functions defined in aggregateExpressions are evaluated only against visible rows in the result set.

  • In the event of an application error on the protocol server during this operation, a SOAP fault is returned, as specified in section 2.2.9. The Id element of the AccessServerMessage MUST be one of the values specified in section 2.2.9.1, one of the values specified in section 2.2.9.2, or one of the values in the following table.

    Identifier

    Description

    GetRecordsPermissionsFailure

    See section 2.2.5.2.

    OrderingException_InvalidSpecification

    See section 2.2.5.2.

    OrderingException_InvalidColumnName

    See section 2.2.5.2.

    InvalidFilterExpression

    See section 2.2.5.2.

    InvalidAggregateExpression

    See section 2.2.5.2.