SQLAppendStatement() function

The SQLAppendStatement() function continues a SQL statement using the contents of a string. A return value indicates if an error occurred during the function call.

InTouch tags can support character strings to a maximum of 131 characters. You typically use the SQLAppendStatement() function to concatenate additional strings to a statement.

Category

SQL

Syntax

[ResultCode=]SQLAppendStatement(ConnectionID, "SQLStatement");

Arguments

ConnectionID

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

SQLStatement

Actual statement to append.

Example

ResultCode=SQLAppendStatement(ConnectionID, "where tablename.columnname=TR-773-01");

See Also

SQLConnect(), SQLClearStatement()