Updates the data in a database identified by connection reference.


icon

Inputs/Outputs

  • cstr.png condition —

    condition specifies an SQL clause that this VI uses to filter the selection criteria. This VI appends this clause to the end of an update statement. For example, where (col1 > 10). If you do not specify a value for this input or if the input is an empty string, this VI updates all rows in table.

  • cfxdt.png data —

    data specifies the new data you want to update in the database.

    If data is a cluster and flatten cluster? is FALSE, this VI updates the columns specified by the columns input with the items in the cluster. The order of each item in the cluster determines the order this VI updates the items in the table. For example, this VI updates the column specified by the 0th element of the columns input with the 0th item in the cluster. If the columns input is empty, this VI updates table from the first column with the 0th item in the cluster. If data is a cluster and flatten cluster? is TRUE, this VI flattens the cluster to a binary value and updates the column specified by the columns input with the binary value. If data is not a cluster, this VI updates the column specified by the columns input with the input data.

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cstr.png table —

    table specifies the name of the table whose data you want to update.

  • c1dstr.png columns —

    columns specifies the names of the columns that you want to update. If you do not specify a value for this input or if the input is an empty array, this VI updates all columns in table.

  • 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 flatten cluster? (F) —

    flatten cluster? specifies whether to insert a cluster that you wire to data as a binary value. If the value is TRUE, this VI updates the column that you specify in the columns input with the flattened binary value of the cluster. If the value is FALSE, this VI updates each column that you specify in the columns input with the corresponding item in the cluster. The default is FALSE.

    Note This input is valid only if you wire a cluster to the data input.
  • idlrn.png connection reference out —

    connection reference out returns a reference to an ADO Connection object.

  • ierrcodeclst.png error out —

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