2.2.3.23 CT_ForEachRecordData

Target namespace: http://schemas.microsoft.com/office/accessservices/2009/11/application

Referenced by: CT_ForEachRecord

Specifies a set of records.

Child Elements:

Parameters : A CT_ParameterValues element that specifies the parameters to either the Query element or the query specified by the Reference element. MUST NOT be present if the Reference element is present and specifies a list.

Query : A CT_Query element that specifies a set of records. MUST NOT be present if the Reference element is present.

Reference : An ST_ObjectName element that specifies a list or query. MUST NOT be present if the Query element is present.

WhereCondition : A CT_Expression element that specifies an expression that selects a set of records from the records in the Query element or in the object specified by the Reference element.

Attributes:

Alias : An ST_ObjectName attribute that specifies a name for this set of records.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_ForEachRecordData">
   <xsd:sequence>
     <xsd:choice>
       <xsd:element name="Query" type="CT_Query" wbld:cname="Query"/>
       <xsd:element name="Reference" type="ST_ObjectName" wbld:cname="Reference"/>
     </xsd:choice>
     <xsd:element name="WhereCondition" minOccurs="0" type="CT_Expression" wbld:cname="WhereCondition"/>
     <xsd:element name="Parameters" minOccurs="0" type="CT_ParameterValues" wbld:cname="Parameters"/>
   </xsd:sequence>
   <xsd:attribute name="Alias" type="ST_ObjectName" wbld:cname="Alias" use="optional"/>
 </xsd:complexType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).