SQLSetParamChar() function

The SQLSetParmChar() function can be used in a script to set the value of the specified parameter to the specified string. The function can be called multiple times before executing, resulting in the parameter value being set to the concatenation of all values sent. Lengths of 0 (zero) are ignored.

Category

SQL

Syntax

SQLSetParamChar(StatementID, ParameterNumber, ParameterValue, MaxLength);

Arguments

StatementID

Integer value returned by SQL when a SQLPrepareStatement() function is used.

ParameterNumber

Parameter number in the statement.

ParameterValue

Value to set as the parameter value.

MaxLength

Maximum width of the column with which this parameter is associated. This setting determines whether the parameter is of varying character or long varying character type. If MaxLength is less than or equal to the largest character string allowed by the database, then the parameter is varying character type. If greater, long varying character type.

See Also

SQLPrepareStatement()