SQLInsertEnd() function
- Last UpdatedJun 17, 2024
- 1 minute read
The SQLInsertEnd function cleans up resources associated with the StatementID function created by SQLInsertPrepare.
Category
SQL
Syntax
[ResultCode=]SQLInsertEnd(ConnectionID, StatementID);
Arguments
ConnectionID
Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.
StatementID
Integer value returned by SQL when a SQLPrepareStatement() function is used.
Example
The following example shows how multiple insert functions should be specified in a script.
ResultCode = SQLSetStatement(ConnectionId, "SET IDENTITY_INSERT Products ON");
ResultCode = SQLExecute(ConnectionId, "", 0);
ResultCode = SQLInsertPrepare(ConnectionId, TableName, Bindlist, StatementID);
ResultCode = SQLInsertExecute(ConnectionId, Bindlist, StatementID);
ResultCode = SQLInsertEnd(ConnectionId, StatementID);
See Also
SQLConnect(), SQLPrepareStatement()