SQLInsertExecute() function

The SQLInsertExecute() function runs the previously prepared insert statement specified by the SQLInsertPrepare() function.

The SQLInsertExecute() function uses the current values of InTouch tags to insert one row into the table identified by the previous SQLInsertPrepare() function. If the BindList argument includes an Identity key field for a MS SQL Server table, it is necessary to set the IDENTITY_INSERT option before running SQLInsertExecute().

The StatementID argument contains an integer value returned by SQL when a previous SQLInsertPrepare() function is run within the script.

Category

SQL

Syntax

[ResultCode=]SQLInsertExecute(ConnectionID, BindList, StatementID);

Arguments

ConnectionID

Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.

BindList

Defines which InTouch tags are used and which database columns they are associated with.

StatementID

Integer value returned by SQL when a SQLPrepareStatement() function is used.

See Also

SQLConnect(), SQLPrepareStatement()