Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

DB Tools Fetch Element Data VI

LabVIEW 2013 Database Connectivity Toolkit Help

Edition Date: June 2013

Part Number: 370016F-01

»View Product Info
Download Help (Windows Only)

Owning Palette: Advanced VIs

Requires: Database Connectivity Toolkit

Retrieves the data located at the column index of the current record in the recordset identified by the recordset reference. The column index can be either the zero-indexed position of the column in the recordset or the name of the column. Wire data to the type input to determine the polymorphic instance to use or manually select the instance.

Examples

Use the pull-down menu to select an instance of this VI.

String (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

String (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Integer (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Integer (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Single (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Single (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Double (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Double (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Date/Time (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Date/Time (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset.
error out contains error information. This output provides standard error out functionality.

Binary (CR)

command-recordset reference specifies a reference that combines an ADO Command object and an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset. Use the Database Variant To Data function to convert this data to its native LabVIEW data type.
error out contains error information. This output provides standard error out functionality.

Binary (R)

recordset reference specifies a reference to an ADO Recordset object.
column index specifies the column from which to retrieve the data. column index can be either an integer, which represents the column position in the table (zero-indexed), or a string, which identifies the column by its name.
type specifies the type of data in the column.
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.
data returns the data retrieved from the recordset. Use the Database Variant To Data function to convert this data to its native LabVIEW data type.
error out contains error information. This output provides standard error out functionality.

Examples

Refer to the following VIs for examples of using the DB Tools Fetch Element Data VI:

  • Database Fetching VI: labview\examples\database
  • Playback (fetching) VI: labview\examples\database

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit