ODBC_SQLProcedureColumns

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLProcedureColumns (stmtID; catalogName; schemaName; procName; columnName) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
catalogNameStringProcedure catalog name
schemaNameStringString search pattern for procedure schema names
procNameStringString search pattern for procedure names
columnNameStringString search pattern for column names
Function resultLongintReturns 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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlprocedurecolumns.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See Also

ODBC_SQLProcedures.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next