SQLInsert() function

The SQLInsert() function inserts a new record into the referenced table using the values of the tags in the supplied BindList. The BindList parameter defines which InTouch tags are used and which database columns they are associated.

Use the SQLInsert() function to prepare, insert, and end the statement.

Category

SQL

Syntax

[ResultCode=]SQLInsert(ConnectionID, TableName, BindList);

Arguments

ConnectionID

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

TableName

Name of the database table you want to access.

BindList

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

Example

The following statement inserts a new record into table ORG with the tag values specified in List1:

ResultCode=SQLInsert(ConnectionID,"ORG","List1");