DataRecordSet class

DataRecordSet class

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

The DataRecordSet type exposes the following members:

Constructors

ConstructorDescription
DataRecordSet()Constructor.

Properties

PropertyDescription
idThe data recordset ID, unique within the document.
connection_idThe connection ID for the associated DataConnection object. Does not exist for XML data sources.
commandThe command string used to query data from the data source.
optionsOptions to apply to the data recordset. Possible values can be any combination of one or more of those shown in the following table.
time_refreshedThe date and time the data recordset was last refreshed.
next_row_idThe next available Visio row ID.
nameThe display (or “friendly”) name of the data recordset.
row_orderWhether 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.
refresh_overwrite_allWhether to overwrite user changes to shape data items in shapes linked to data when the data recordset is refreshed.
refresh_no_reconciliation_uiWhether the data-reconciliation user interface should be disabled. True (1) to disable the user interface (UI). False (0) to enable the UI.
refresh_intervalHow often (in minutes) Visio refreshes the data recordset automatically. This value must be 1 or larger.
replace_linksDefines 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. If this attribute is absent, Visio asks the user whether to replace links on copy or cut.
checksumA checksum value, generated by Visio, and based on data-recordset properties. Set this attribute to 0; Visio recalculates this value at runtime.
ado_dataContains XML that conforms to the ADO classic XML schema for an ADO recordset and that describes the data in the data recordset.
refresh_conflictsIndicates a row in the data recordset linked to a shape that is in conflict after the data recordset is refreshed.
RowID - Indicates a row in the data recordset linked to a shape that is in conflict after the data recordset is refreshed.
ShapeID - Shape ID of the shape involved in the conflict.
PageID - Page ID of the shape involved in the conflict.
row_mapsMaps a data-recordset row to a shape.
RowID - Row ID of the row, unique within the data recordset.
ShapeID - Shape ID of the shape linked to data in the data-recordset row identified by RowID.
PageID - Page ID of the shape linked to data in the data-recordset row identified by RowID.
auto_link_comparisonDefines 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.
data_columnsContains all the DataColumn elements in a data recordset.

Methods

MethodDescription
refresh()Executes the query string associated with the connected (non-XML-based) DataRecordset and updates linked shapes with new data from the data source returned by the query.
refresh(connection_type)Executes the query string associated with the connected (non-XML-based) DataRecordset and updates linked shapes with new data from the data source returned by the query.

See Also