Share via

2.2.3.6 CT_Reference

  • Article

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

Referenced by: CT_References

Specifies one input source to the parent CT_Query (section 2.2.3.18).

Child Elements:

ReferenceParameters: A CT_Parameters element (section 2.2.3.13) that specifies parameters of the input source. If a CT_Parameter (section 2.2.3.12) specified in this element has the same Name attribute as a CT_Parameter in the Parameters element of the parent CT_Query (section 2.2.3.18) or in the ReferenceParameters element of a different CT_Reference in the same parent CT_Query, their Type attributes MUST be the same.

If the parent CT_Query is used as an input source to another query, the parameters in CT_Query and the parameters in ReferenceParameters in order of input sources MUST be listed in ReferenceParameters of the References element in another query. While adding the ReferenceParameters of input sources to the list, the parameter MUST be skipped if a CT_Parameter with the same Name has already been added. 

Attributes:

Alias: An ST_ObjectName attribute (section 2.2.4.1) that specifies an alias for the input source. This alias MUST be used throughout the Query object to refer to the input source as if it had been named this alias. The value MUST be unique among all Alias attribute values under the CT_References collection (section 2.2.3.7).

Source: An ST_ObjectName attribute that specifies a table or a named query (section 2.1.3) that contains data included in the query CT_Results (section 2.2.3.9).

Type: An ST_QuerySourceType attribute (section 2.2.4.18) that specifies the type of the input source.

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

 <xsd:complexType name="CT_Reference">
   <xsd:all>
     <xsd:element name="ReferenceParameters" minOccurs="0" type="CT_Parameters" wbld:cname="ReferenceParameters"/>
   </xsd:all>
   <xsd:attribute name="Source" type="ST_ObjectName" use="required" wbld:cname="Source"/>
   <xsd:attribute name="Alias" type="ST_ObjectName" wbld:cname="Alias" use="optional"/>
   <xsd:attribute name="Type" type="ST_QuerySourceType" default="Table" wbld:cname="Type" use="optional"/>
 </xsd:complexType>

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