Executes an SQL query and returns a recordset reference that you must eventually free with the DB Tools Free Object VI. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.


icon

Inputs/Outputs

  • ci32.png cache size (1) —

    cache size specifies the number of records to store in local memory. After you retrieve the number of records in local memory and you request the next record, the current set of records is discarded from local memory and the next set are retrieved into local memory. The default is 1.

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png SQL query —

    SQL query specifies the SQL statement to execute.

  • cenum.png cursor type —

    cursor type specifies the method for navigating the recordset. Some providers and/or databases do not support all cursors.

  • 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 recordset reference —

    recordset reference returns a reference to an ADO Recordset object.

  • ierrcodeclst.png error out —

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