ODBC_SQLColumns

4D v16

ODBC_SQLColumns


ODBC_SQLColumns ( stmtID ; catalogName ; schemaName ; tableName ; columnName ) -> Resultado

Parámetro	Tipo	Descripción
stmtID	Entero largo	Statement ID
catalogName	Cadena	Catalog name
schemaName	Cadena	String search pattern for schema names
tableName	Cadena	String search pattern for table names
columnName	Cadena	String search pattern for column names
Resultado	Entero largo	Returns the result of the MS ODBC API function SQLColumns

Descripción

The ODBC_SQLColumns command returns the list of column names in specified tables. The driver returns this information as a result set on the specified stmtID.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the string search pattern for schema names.

tableName is the string search pattern for table names.

columnName is the string search pattern for column names.

For more information, please see the SQLColumns function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms711683(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Ver también

ODBC_SQLColumnPrivileges