Help Center›AfxNova›CODBCStmt Class

CODBCStmt.GetProcedureColumnsmethod

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures.

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION GetProcedureColumns (BYREF wszCatalogName AS WSTRING, BYVAL CatalogNameLength AS SQLSMALLINT, BYREF wszSchemaName AS WSTRING, BYVAL SchemaNameLength AS SQLSMALLINT, BYREF wszProcName AS WSTRING, BYVAL ProcNameLength AS SQLSMALLINT, BYREF wszColumnName AS WSTRING, BYVAL ColumnNameLength AS SQLSMALLINT) AS SQLRETURN

Parameters

Name		Description
`wszCatalogName`		Procedure catalog name. If a driver supports catalogs for some procedures but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes those procedures that do not have catalogs. wszCatalogName cannot contain a string search pattern.
`CatalogNameLength`		Length of wszCatalogName.
`wszSchemaName`		String search pattern for procedure schema names. If a driver supports schemas for some procedures but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes those procedures that do not have schemas.
`SchemaNameLength`		Length of wszSchemaName.
`wszProcName`		String search pattern for procedure names.
`ProcNameLength`		Length of wszProcName.
`wszColumnName`		String search pattern for column names.
`ColumnNameLength`		Length of wszColumnName.

Return value

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures.

Reference

Include file CODBCStmt.inc
Defined in AfxNova/COdbcStmt.inc:2080
Documented in Databases/ODBC Classes/CODBCStmt Class.md
Topic: CODBCStmt Class