4D Doc Center : ODBC

Home

4D v14.1

ODBC_SQLNumParams


ODBC_SQLNumParams ( stmtID ; parameterCount ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
parameterCount	Longint	Number of parameters in the statement
Function result	Longint	Returns the result of the MS ODBC API function SQLNumParams

The ODBC_SQLNumParams command returns the number of parameters in an SQL statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

parameterCount is the number of parameters in the statement specified by stmtID.

For more information, please see the SQLNumParams function in the MS ODBC API at http://msdn.microsoft.com/en-us/library/ms715409(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See the example for the ODBC_SQLExecute command.