4D v13

ODBC_SQLProcedureColumns

Home

 
4D v13
ODBC_SQLProcedureColumns

ODBC_SQLProcedureColumns 


 

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

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.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16942

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLProcedures