SQLInsertPrepare() function

The SQLInsertPrepare() function creates and prepares an Insert statement each time the function runs. The Insert statement is not processed. The StatementID argument is an integer tag containing a value after the statement is processed.

Category

SQL

Syntax

[ResultCode=]SQLInsertPrepare (ConnectionID, TableName, BindList, StatementID);

Arguments

ConnectionID

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

TableName

The name of the database table to access.

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()