DataRecordSet element (DataRecordSets_Type complexType) (Visio XML)

Article
03/09/2022

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

Element information

	Value
Element type	DataRecordSet_Type
Namespace	http://schemas.microsoft.com/office/visio/2012/main
Schema file	VisioSchema15.xsd
Document parts	recordsets.xml

Definition

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

Elements and attributes

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.