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 command reference —

    command reference specifies a reference to an ADO Command object.

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

    command-recordset reference returns a reference that combines an ADO Command object and an ADO Recordset object.

  • ierrcodeclst.png error out —

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