Database Variant To Data (G Dataflow)

Download Manual | Offline Viewer Required

Version:

Last Modified: February 27, 2020

Converts a database variant to a LabVIEW NXG data type you specify.

database variant

Variant data you want to convert to the data type specified in type.

error in

Error conditions that occur before this node runs.

The node responds to this input according to standard error behavior.

Standard Error Behavior

Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.

error in does not contain an error	error in contains an error

If no error occurred before the node runs, the node begins execution normally. If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.	If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.

Default: No error

type

Data type into which you want to convert variant data.

data

Cluster data retrieved from the Recordset.

error out

Error information.

The node produces this output according to standard error behavior.

Standard Error Behavior

error in does not contain an error	error in contains an error

If no error occurred before the node runs, the node begins execution normally. If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.	If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.

Variant to Data Details

You can wire a variant, a 1D array of variants, or a 2D array of variants to the database variant input. Depending on the data type that you wire to the type and database variant inputs, this node performs the following different conversions:

Data Type Wired to database variant Input	Data Type Wired to type Input
Data Type Wired to database variant Input	Cluster	1D Array of Non-Clusters	1D Array of Clusters	2D Array	Others
Variant	Converts the variant to the LabVIEW NXG data type specified by the type input.	Converts the variant to the LabVIEW NXG data type specified by the type input.	Converts the variant to the LabVIEW NXG data type specified by the type input.	Converts the variant to the LabVIEW NXG data type specified by the type input.	Converts the variant to the LabVIEW NXG data type specified by the type input.
1D Array of Variants	Converts each element of the 1D array to a column in a sequence.	Converts each element of the 1D array to the data type specified by the type input.	Converts each element of the 1D array to a cluster. The output is a 1D array of clusters.	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.
2D Array of Variants	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.	Converts each row of the 2D array to a cluster. The output is a 1D array of clusters.	Converts each element of the 2D array to the element data type specified by the type input.	Results in a broken wire at the database variant input.
Others	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.	Results in a broken wire at the database variant input.

Where This Node Can Run:

Desktop OS: Windows

FPGA: Not supported

Web Server: Not supported in VIs that run in a web application

Table Of Contents