Share via

2.2.3.21 CT_ForEachRecordData

  • Article

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: CT_ForEachRecord

Specifies a set of records.

Child Elements:

Parameters: A CT_ParameterValues (section 2.2.3.17) element that specifies the parameters to the query (section 2.1.3) specified by the Reference element. MUST NOT be present if the Reference element specifies a Table (section 2.1.1).

Reference: An ST_ObjectName (section 2.2.4.1) element that specifies a Table (section 2.1.1) or a Query (section 2.1.3).

WhereCondition: A CT_Expression (section 2.2.3.1) element that specifies an expression that selects a set of records from the records in the object specified by the Reference element.

Attributes:

Alias: An ST_ObjectName (section 2.2.4.1) 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:element name="Reference" type="ST_ObjectName" wbld:cname="Reference"/>
     <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.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).