DB Tools Update Data VI

Owning Palette: Database VIs and Function

Requires: Database Connectivity Toolkit

Updates the data in a database identified by connection reference.

Example

	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.
	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.
	connection reference specifies a reference to an ADO Connection object.
	table specifies the name of the table whose data you want to update.
	columns specifies the names of the columns that you want to update. Note  If data is a cluster and flatten cluster? is TRUE, you can specify only one column name. This VI updates the column you specify with the flattened binary value. If you do not wire this input, this VI updates the first column with the flattened binary value. If data is a cluster and flatten cluster? is FALSE, the array size of columns must equal the number of elements in the cluster.
	error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
	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.
	connection reference out returns a reference to an ADO Connection object.
	error out contains error information. This output provides standard error out functionality.

Example

Refer to the Database Update VI in the labview\examples\database directory for an example of using the DB Tools Update Data VI.