DB Tools Get Parameter Value VI

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.

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.