Creates a parameterized SQL query and returns a command reference that you must free eventually. Unless you are detecting the parameters automatically, the number of elements in the parameters array must match the number of parameters you specify in SQL query. For stored procedures, set stored procedure to TRUE and SQL query to the name of the procedure you want to execute.


icon

Inputs/Outputs

  • cbool.png auto-detect parameters? (F) —

    auto-detect parameters? if TRUE, this VI attempts to detect the parameters automatically using the SQL query or the stored procedure name.

    Note Automatically detecting parameters can be a time-consuming process and is not supported by all databases and/or database providers/drivers.
  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png SQL query —

    SQL query specifies a parameterized SQL query or stored procedure name.

  • c1dcclst.png parameters —

    parameters specifies the parameter information.

  • cstr.png parameter name —

    parameter name is the name of parameter.

  • cenum.png type —

    type is the data type of parameter.

    0String
    1Long (I32)
    2Single (SGL)
    3Double (DBL)
    4Date/Time
    5Binary
  • cenum.png direction —

    direction of the parameter value (Input, Output, Input/Output, or Return value).

    0Input (default)
    1Output
    2Input/Output
    3Return Value
  • cfxdt.png value —

    value a variant that contains the parameter value.

  • cerrcodeclst.png error in (no error) —

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

  • cbool.png stored procedure? (F) —

    stored procedure? specifies that this query is a stored procedure call.

  • idlrn.png command reference —

    command reference returns a reference to an ADO Command object.

  • i1dcclst.png parameters out —

    parameters out returns an array of clusters of parameter information.

    0Input
    1Output
    2Input/Output
    3Return Value
  • istr.png parameter name —

    parameter name is the name of parameter.

  • ienum.png type —

    type is the data type of parameter.

  • ienum.png direction —

    direction of the parameter value (Input, Output, Input/Output, or Return value).

  • ifxdt.png value —

    value a variant that contains the parameter value.

  • ierrcodeclst.png error out —

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