ODBC_SQLProcedures

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

version 2004


ODBC_SQLProcedures (stmtID; catalogName; schemaName; procName) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
catalogNameStringProcedure catalog name
schemaNameStringString search pattern for procedure schema names
procNameStringString search pattern for procedure names
Function resultLongintReturns the result of the MS ODBC API function
SQLProcedures

Description

The ODBC_SQLProcedures command returns the list of procedure names stored in a specific data source. Procedure is a generic term used to describe an executable object, or a named entity that can be invoked using input and output parameters.

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.

For more information, please see the SQLProcedures function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlprocedures.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

See Also

ODBC_SQLProcedureColumns.


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