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

    command reference specifies a reference to an ADO Command 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 reference out —

    command reference out returns a reference to an ADO Command 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.