4D v13

ODBC_SQLColumns

Home

 
4D v13
ODBC_SQLColumns

ODBC_SQLColumns 


 

ODBC_SQLColumns ( stmtID ; catalogName ; schemaName ; tableName ; columnName ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
catalogName  String in Catalog name
schemaName  String in String search pattern for schema names
tableName  String in String search pattern for table names
columnName  String in String search pattern for column names
Function result  Longint in Returns the result of the MS ODBC API function SQLColumns

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.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16945

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLColumnPrivileges