ODBC_SQLProcedures

4D v16

ODBC_SQLProcedures


ODBC_SQLProcedures ( stmtID ; catalogName ; schemaName ; procNom ) -> Résultat

Paramètre	Type	Description
stmtID	Entier long	Statement ID
catalogName	Chaîne	Procedure catalog name
schemaName	Chaîne	String search pattern for procedure schema names
procNom	Chaîne	String search pattern for procedure names
Résultat	Entier long	Returns 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 Reference at http://msdn.microsoft.com/en-us/library/ms715368(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Voir aussi

ODBC_SQLProcedureColumns