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.
|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.|
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.