4D Doc Center : ODBC_SQLProcedureColumns

Home

4D v14.1

ODBC_SQLProcedureColumns


ODBC_SQLProcedureColumns ( stmtID ; catalogName ; schemaName ; procName ; columnName ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
catalogName	String	Procedure catalog name
schemaName	String	String search pattern for procedure schema names
procName	String	String search pattern for procedure names
columnName	String	String search pattern for column names
Function result	Longint	Returns the result of the MS ODBC API function SQLProcedureColumns

Description

The ODBC_SQLProcedureColumns command returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. The driver returns the information as a result set on the specified statement.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the procedure catalog name.

schemaName is the string search pattern for procedure schema names.

procName is the string search pattern for procedure names.

columnName is the string search pattern for column names.

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

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.