Table Of Contents

DB Tools Update Data (G Dataflow)

Version:
    Last Modified: August 13, 2019

    Updates data in a table or group of tables.

    connector_pane_image
    datatype_icon

    condition

    SQL clause that filters selection criteria. The clause appends to the end of a delete statement. Wire an empty string to this input to delete all tables.

    datatype_icon

    data

    New data you want to update in the database.

    This node updates the columns specified by the columns input when your data is a cluster and flatten cluster? is False. The node updates items in the table based on the order of items in the cluster.

    This node flattens the cluster to a binary value and updates the column specified by the columns input cluster when flatten cluster? is True.

    This node updates table input from the first column with the 0th item in the cluster when the columns input is empty.

    datatype_icon

    connection reference

    Reference to an ADO Connection object. Connection objects represent a connection with a data source, including methods to open and close a connection with a database, which database to connect with, and the level of isolation for database transactions.

    datatype_icon

    table

    Name of the table in the database from which to select data.

    You can specify multiple tables by using commas as the delimiter.

    datatype_icon

    columns

    Target column in the table for data insertion.

    Wire an empty array to this input if you want to use all columns in the table.

    datatype_icon

    error in

    Error conditions that occur before this node runs.

    The node responds to this input according to standard error behavior.

    Standard Error Behavior

    Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.

    error in does not contain an error error in contains an error
    If no error occurred before the node runs, the node begins execution normally.

    If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.

    If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.

    Default: No error

    datatype_icon

    flatten cluster?

    A Boolean value that determines whether to insert flattened clusters from the data input into a binary value.

    True Attempts to insert flattened cluster as a binary value.
    False Treats items in cluster as individual column values.
    datatype_icon

    error out

    Error information.

    The node produces this output according to standard error behavior.

    Standard Error Behavior

    Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.

    error in does not contain an error error in contains an error
    If no error occurred before the node runs, the node begins execution normally.

    If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.

    If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.
    datatype_icon

    connection reference out

    Reference to an ADO Connection object. Connection objects represent a connection with a data source, including methods to open and close a connection with a database, which database to connect with, and the level of isolation for database transactions.

    Where This Node Can Run:

    Desktop OS: Windows

    FPGA: Not supported

    Web Server: Not supported in VIs that run in a web application


    Recently Viewed Topics