Expand Minimize

DataRecordSet element (DataRecordSets_Type complexType) ('Visio XML')

Office 2013

Last modified: January 09, 2014

Applies to: Office 2013 | Office 365 | Visio 2013

In this article
Element information
Definition
Elements and attributes

Stores, formats, refreshes, and exposes data queried from a database in Microsoft Visio.

Element type

DataRecordSet_Type

Namespace

http://schemas.microsoft.com/office/visio/2012/main

Schema file

VisioSchema15.xsd

Document parts

recordsets.xml

< xs:element name="DataRecordSet" type="DataRecordSet_Type" minOccurs="0" maxOccurs="unbounded" >
</xs:element >

If the schema defines specific requirements, such as sequence, minOccurs, maxOccurs, and choice, see the definition section.

Parent elements

Element

Type

Description

DataRecordSets

DataRecordSets_Type

Contains all the DataRecordset elements in the document.

Child elements

Element

Type

Description

ADOData

ADOData_Type

Contains XML that conforms to the ADO classic XML schema for an ADO recordset and that describes the data in the data recordset.

AutoLinkComparison

AutoLinkComparison_Type

Defines a rule that compares a column in the parent DataRecordset element with a shape data item from the last successful automatic linking action performed in the user interface.

DataColumn

DataColumns_Type

Defines how a data column appears in the External Data window in the Visio user interface and qualifies the data in the column by defining its data type and formatting.

DataColumns

DataColumns_Type

Contains all the DataColumn elements in a data recordset.

PrimaryKey

PrimaryKey_Type

Identifies one or more primary-key columns in the data recordset.

RefreshConflict

RefreshConflict_Type

Indicates a row in the data recordset linked to a shape that is in conflict after the data recordset is refreshed.

RowMap

RowMap_Type

Maps a data-recordset row to a shape.

Attributes

Attribute

Type

Required

Description

Possible values

Checksum

xsd:unsignedInt

optional

A checksum value, generated by Visio, and based on data-recordset properties. Set this attirbute to 0; Visio recalculates this value at runtime.

Values of the xsd:unsignedInt type.

Command

xsd:string

optional

The command string used to query data from the data source.

Values of the xsd:string type.

ConnectionID

xsd:unsignedInt

optional

The connection ID for the associated DataConnection object. Does not exist for XML data sources.

Values of the xsd:unsignedInt type.

ID

xsd:unsignedInt

required

The data recordset ID, unique within the document.

Values of the xsd:unsignedInt type.

Name

xsd:string

optional

The display (or "friendly") name of the data recordset.

Values of the xsd:string type.

NextRowID

xsd:unsignedInt

optional

The next available Visio row ID.

Values of the xsd:unsignedInt type.

Options

xsd:unsignedInt

optional

Options to apply to the data recordset. Possible values can be any combination of one or more of those shown in the following table.

Values of the xsd:unsignedInt type.

RefreshInterval

xsd:unsignedInt

optional

How often (in minutes) Visio refreshes the data recordset automatically. This value must be 1 or larger.

Values of the xsd:unsignedInt type.

RefreshNoReconciliationUI

xsd:boolean

optional

Whether the data-reconciliation user interface should be disabled. True (1) to disable the user interface (UI). False (0) to enable the UI.

Values of the xsd:boolean type.

RefreshOverwriteAll

xsd:boolean

optional

Whether to overwrite user changes to shape data items in shapes linked to data when the data recordset is refreshed.

Values of the xsd:boolean type.

ReplaceLinks

xsd:unsignedInt

optional

Defines how shape-data links are treated when shapes are copied or cut. 1 to replace existing links in the target shape. 0 to maintain existing links in the target shape.

Values of the xsd:unsignedInt type.

RowOrder

xsd:boolean

optional

Whether to use the order of the rows in the data recordset as the primary key. True (1) if row IDs are determined by row order. False (0) if row IDs are determined by values in the primary key column(s) of the data recordset.

Values of the xsd:boolean type.

TimeRefreshed

xsd:dateTime

optional

The date and time the data recordset was last refreshed.

Values of the xsd:dateTime type.

Show:
© 2014 Microsoft