DB Tools Move To Record N VI

Owning Palette: Advanced VIs

Requires: Database Connectivity Toolkit

Moves the cursor to point to record n in the recordset. To move the cursor to the last record, set n to –1. You cannot use this VI with a forward-only cursor. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.

Example

Move To Record N (R)

	recordset reference specifies a reference to an ADO Recordset object.
	n specifies to which recordset to move the cursor. To move the cursor to point to the last record, set n to –1.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	recordset reference out returns a reference to an ADO Recordset object.
	error out contains error information. This output provides standard error out functionality.

Move To Record N (CR)

	command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
	n specifies to which recordset to move the cursor. To move the cursor to point to the last record, set n to –1.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	command-recordset reference out returns a reference that combines an ADO Command object and an ADO Recordset object.
	error out contains error information. This output provides standard error out functionality.

Example

Refer to the Using Connection Strings VI in the labview\examples\database\EXE directory for an example of using the DB Tools Move To Record N VI.