function
|
SQLColumns
|
|
Library: omodbc - low-level ODBC support
Include: omodbc.xin
|
Return type: Integer
Returns: An SQL return code. The following values may be returned:
- SQL_SUCCESS (the list was retrieved).
- SQL_SUCCESS_WITH_INFO (the list was retrieved, but a message was issued).
- SQL_ERROR (an error occurred).
- SQL_INVALID_HANDLE (the handle is invalid).
- SQL_STILL_EXECUTING (the program is still executing).
|
Declaration define external integer function SQLColumns
( read-only SQL_handle_type StatementHandle,
value stream CatalogName,
value integer NameLength1,
value stream SchemaName,
value integer NameLength2,
value stream TableName,
value integer NameLength3,
value stream ColumnName,
value integer NameLength4 )
Purpose
Returns the list of column names in specified tables. The information is returned as a result set on the specified statement handle.
Input arguments:
- StatementHandle.
- CatalogName.The catalog name. If a driver supports catalogs for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without catalogs. CatalogName cannot contain a string search pattern.
- NameLength1. The length of CatalogName.
- SchemaName. The string-search pattern for schema names. If a driver supports schemas for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without schemas.
- NameLength2. The length of SchemaName.
- TableName. The string-search pattern for table names.
- NameLength3. The length of TableName.
- ColumnName. The string-search pattern for column names.
- NameLength4. The length of ColumnName.
Generated: August 11, 2000 at 3:07:52 pm
If you have any comments about this section of the documentation, send email to docerrors@omnimark.com
Copyright © OmniMark Technologies Corporation, 1988-2000.