Gets properties of the object as determined by the inputs. This VI works for connections, commands, recordsets, columns, and parameters. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.


icon

Inputs/Outputs

  • cdlrn.png command-recordset reference —

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

  • 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 out —

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

  • icclst.png command properties —

    command properties returns the following properties that define the most recent SQL query.

  • ii32.png parameter count —

    parameter count returns the number of parameters.

  • istr.png command text —

    command text returns the parameterized SQL command.

  • ii32.png command timeout (s) —

    command timeout (s) returns the length of time, in seconds, the VI waited while attempting to execute a command before quitting and returning an error.

  • ierrcodeclst.png error out —

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