4D v14.1ODBC_SQLProcedures |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v14.1
ODBC_SQLProcedures
|
ODBC_SQLProcedures ( stmtID ; catalogName ; schemaName ; procName ) -> 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 | |||||
Function result | Longint |
![]() |
Returns the result of the MS ODBC API function SQLProcedures | |||||
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 Reference at http://msdn.microsoft.com/en-us/library/ms715368(VS.85).aspx.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
Product: 4D
Theme: ODBC_Catalog functions
Number:
16941
Created: 4D ODBC Pro 2004
4D ODBC Pro ( 4D ODBC Pro v11.4)
4D ODBC Pro ( 4D ODBC Pro v12)
4D ODBC Pro ( 4D v13)
4D ODBC Pro ( 4D v14 R3)
4D ODBC Pro ( 4D v14.1)
4D ODBC Pro ( 4D v14 R2)
4D ODBC Pro ( 4D v14 R4)