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

DB Tools Get Parameter Value 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 value of the parameter specified by the parameter index input in the command or command-recordset. The parameter index can be either the zero-indexed position of the parameter in the command or the name of the parameter. Wire data to the type input to determine the polymorphic instance to use or manually select the instance.

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

String (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

Integer (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

Single (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

Double (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

Date/Time (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

Binary (C)

command reference specifies a reference to an ADO Command object.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
command reference out returns a reference to an ADO Command object.
value returns the value of the parameter.
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.
parameter index specifies either the ordinal index of the parameter or the name of the parameter.
type specifies the data type of parameter.
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.
value returns the value of the parameter.
error out contains error information. This output provides standard error out functionality.

 

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