4D v16

ODBC_SQLProcedures

Home

 
4D v16
ODBC_SQLProcedures

ODBC_SQLProcedures 


 

ODBC_SQLProcedures ( stmtID ; catalogName ; schemaName ; procName ) -> 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
Function result  Longint in 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.



See also 

ODBC_SQLProcedureColumns

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16941

 
HISTORY 

Created: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)