4D v13
ODBC_SQLColumns
ODBC_SQLColumns
| ODBC_SQLColumns ( stmtID ; catalogName ; schemaName ; tableName ; columnName ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtID | Longint |
|
Statement ID | |||||
| catalogName | String |
|
Catalog name | |||||
| schemaName | String |
|
String search pattern for schema names | |||||
| tableName | String |
|
String search pattern for table names | |||||
| columnName | String |
|
String search pattern for column names | |||||
| Function result | Longint |
|
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.
Product: 4D
Theme: ODBC_Catalog functions
Number:
16945
Created: 4D ODBC Pro 2004
