Share via

2.3.4.2.39 DataRecordSet_Type

  • Article

Target namespace: http://schemas.microsoft.com/office/visio/2011/1/core

Referenced by: DataRecordSets_Type

A complex type that specifies a recordset and the data binding between that recordset and shapes in drawing pages.

Child Elements:

Rel: A Rel_Type element that is unused and MUST be ignored.

DataColumns: A DataColumns_Type element that specifies the fields of the recordset.

PrimaryKey: A PrimaryKey_Type element that specifies a component of the primary key of the recordset. If the RowOrder attribute does not exist or equals zero, there MUST be at least one occurrence of this element. If the RowOrder attribute exists and is equal to one, this element MUST NOT exist.

RowMap: A RowMap_Type element that specifies the data binding between a row in the recordset  and a shape.

RefreshConflict: A RefreshConflict_Type element that is unused and MUST be ignored.

AutoLinkComparison: An AutoLinkComparison_Type element that is unused and MUST be ignored.

Attributes:

ID: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the identifier of the recordset. It MUST be unique amongst all the DataRecordSet_Type child elements of the containing DataRecordSets_Type.

ConnectionID: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the identifier of the data connection that corresponds to the recordset. It MUST be the value of the ID attribute of the DataConnection_Type element associated with the data connection.

Command: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the query for the data connection that corresponds to the recordset.

Options: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies additional information about the recordset. The value MUST be zero or a bitwise OR combination of one or more values in the following table.

Value

Description

1

Specifies that the recordset does not participate in refresh operations.

2

Unused, and MUST be ignored.

4

Unused, and MUST be ignored.

8

Unused, and MUST be ignored.

16

Unused, and MUST be ignored.

TimeRefreshed: An xsd:dateTime ([XMLSCHEMA2] section 3.2.7) attribute that is unused and MUST be ignored.

NextRowID: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that is unused and MUST be ignored.

Name: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the display name of the recordset.

RowOrder: An xsd:boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the recordset uses the row number as the primary key to bind rows of data in the recordset to shapes. It MUST be zero or one. A value of one specifies that the row number is used. If one or more PrimaryKey_Type child elements exist, this attribute MUST NOT exist or MUST be zero. If no PrimaryKey_Type child elements exist, this attribute MUST exist and MUST be one.

RefreshOverwriteAll: An xsd:boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies the conditions where a refresh operation on the recordset will update shape data values in shapes bound to the rows of the recordset. It MUST be equal to zero or one. A value of one specifies that data in shapes bound to the rows of the recordset will be updated with new data from the refreshed rows. A value of zero specifies that only the shape data values where there is a corresponding Cell_Type element with an N attribute equal to "DataLinked" and a V attribute equal to "1" will be updated with new data from the refreshed row.

RefreshNoReconciliationUI: An xsd:boolean ([XMLSCHEMA2] section 3.2.2) attribute that is unused and MUST be ignored.

RefreshInterval: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that is unused and MUST be ignored.

ReplaceLinks: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that is unused and MUST be ignored.

Checksum: An xsd:unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that is unused and MUST be ignored.

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

 <xsd:complexType name="DataRecordSet_Type">
   <xsd:sequence>
     <xsd:element name="Rel" type="Rel_Type" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="DataColumns" type="DataColumns_Type" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="PrimaryKey" type="PrimaryKey_Type" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="RowMap" type="RowMap_Type" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="RefreshConflict" type="RefreshConflict_Type" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element name="AutoLinkComparison" type="AutoLinkComparison_Type" minOccurs="0" maxOccurs="unbounded"/>
   </xsd:sequence>
   <xsd:attribute name="ID" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="ConnectionID" type="xsd:unsignedInt"/>
   <xsd:attribute name="Command" type="xsd:string"/>
   <xsd:attribute name="Options" type="xsd:unsignedInt"/>
   <xsd:attribute name="TimeRefreshed" type="xsd:dateTime"/>
   <xsd:attribute name="NextRowID" type="xsd:unsignedInt"/>
   <xsd:attribute name="Name" type="xsd:string"/>
   <xsd:attribute name="RowOrder" type="xsd:boolean"/>
   <xsd:attribute name="RefreshOverwriteAll" type="xsd:boolean"/>
   <xsd:attribute name="RefreshNoReconciliationUI" type="xsd:boolean"/>
   <xsd:attribute name="RefreshInterval" type="xsd:unsignedInt"/>
   <xsd:attribute name="ReplaceLinks" type="xsd:unsignedInt"/>
   <xsd:attribute name="Checksum" type="xsd:unsignedInt"/>
 </xsd:complexType>