Table Of Contents

Insert Data (G Dataflow)

Last Modified: February 27, 2020

Inserts a new row in a database table.

connector_pane_image
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

data

Data you want to insert into the database.

If data is a cluster, the node inserts each item in the cluster in the table corresponding to each element in the columns input.

For example, the 0th item in the cluster is inserted into the column name in the 0th element of the columns input.

If the columns input is empty, the 0th item of the cluster is inserted into the first column in table.

If data is not a cluster, data is inserted into the column specified by the columns input.

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

create table?

A Boolean value that determines whether to create a table.

The node creates a table with column names provided in the columns input.

spd-note-note
Note

If the columns input is empty, the node names the columns Col0, Col1, and so on. The node determines the type information of the columns created using the data input. If the data input is a cluster, each item in the cluster corresponds to a column in the table.

spd-note-note
Note

For string column types, the size is set equal to the size of the data.

datatype_icon

use file?

A Boolean value that determines whether to use a user-supplied file to determine native database types.

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.

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.

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