SQLSetNextParameter - cSQLStatement
Pass a parameter for a parameterized query or stored procedure. Automatically increments the parameter number.
Type: Procedure
Parameters
| Parameter | Type | Description |
|---|---|---|
| sParamValue | String | Parameter value |
| iParamType | Integer |
Syntax
Procedure SQLSetNextParameter String sParamValue Integer iParamType
Call Example
Send SQLSetNextParameter sParamValue iParamType
Description
SQLSetNextParameter can be used to pass a number of parameters to a parametrized query without specifying the parameter number.
Automatically increments the parameter number and then call SQLSetParameter.
Use of SQLSetNextParameter makes it easier to insert or delete parameters in a query, as parameter numbers don't have to be moved.
The last used parameter number value is stored in piLastArgument.
SQLPrepare, SQLExecute, SQLEXECDirect and SQLSetProcedureName will reset piLastArgument to 0.