SQLClearParam() function

The SQLClearParam() function clears the value of the specified parameter. One of the SQLSetParamxxx() functions must be called again to reload parameters before calling the SQLExecute() function to run the query.

Category

SQL

Syntax

[ResultCode=]SQLClearParam(StatementID,ParameterNumber);

Arguments

StatementID

Integer value returned when a SQLPrepareStatement() function runs.

ParameterNumber

The ParameterNumber argument identifies the actual argument within the SQL statement to modify. Set the value of ParameterNumber associated with StatementID to zero or a zero-length string, depending on whether the argument is numeric or a string.

See Also

SQLPrepareStatement(), SQLExecute()