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.


icon

Inputs/Outputs

  • cstr.png condition —

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

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png table —

    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.

  • c1dstr.png columns —

    columns specifies the columns in table from which to select data. If this array is empty, all columns in the table are returned.

  • cerrcodeclst.png error in (no error) —

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • idlrn.png connection reference out —

    connection reference out returns a reference to an ADO Connection object.

  • i2dfxdt.png data —

    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.

  • ierrcodeclst.png error out —

    error out contains error information. This output provides standard error out functionality.