DB Tools Select Data VI

Owning Palette: Database VIs and Function

Requires: Database Connectivity Toolkit

Selects data from the table in the database identified by connection reference using the columns supplied in the columns array.

This VI returns the data as a 2D array of variants. You can convert each element in the array to its native LabVIEW data type using the Database Variant To Data function.

Example

	condition specifies an SQL clause that this VI uses to filter the selection criteria. This VI appends this clause to the end of a select statement. For example, where (col1 > 10).
	connection reference specifies a reference to an ADO Connection object.
	table is the name of the table in the database from which to select data. You can specify multiple tables by using commas as the delimiter.
	columns specifies the columns in table from which to select data. If this array is empty, all columns in the table are returned.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	connection reference out returns a reference to an ADO Connection object.
	data returns a 2D array of database variants that contains the selected data. 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.

Example

Refer to the Connect to ACCDB Database VI in the labview\examples\database directory for an example of using the DB Tools Select Data VI.