MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Support: Full
ODBC API Conformance: Core Level
Returns descriptor information for a column in a result set. Descriptor information is returned as a character string, a 32-bit descriptor-dependent value, or an integer value.
Note SQLColAttributes cannot be used to return information about the bookmark column (column 0).
The Visual FoxPro ODBC Driver supports all fDescType values. The following table includes comments on the driver's implementation of selected values.
fDescType | Comment |
SQL_COLUMN_AUTO_INCREMENT | Returns FALSE: Visual FoxPro has no counter fields. |
SQL_COLUMN_CASE_SENSITIVE | Always returns TRUE if the column type is Character. |
SQL_COLUMN_LABEL | Returns the column name, which is also returned by SQL_COLUMN_NAME. |
SQL_COLUMN_MONEY | Returns TRUE if the column type is Currency (represented by a "Y" in the Visual FoxPro language). |
SQL_COLUMN_OWNER_NAME | Always returns an empty string. |
SQL_COLUMN_QUALIFIER_NAME | Always returns an empty string. |
SQL_COLUMN_SEARCHABLE | Returns SQL_UNSEARCHABLE for columns of type General; these columns cannot be used in a WHERE clause.
Returns SQL_SEARCHABLE for columns of type Character or Memo with NOCPTRANS not set; these columns can be used in a WHERE clause with any comparison operator. Returns SQL_ALL_EXCEPT_LIKE for all other column types; these columns can be used in a WHERE clause with all comparison operators except LIKE. |
SQL_COLUMN_TABLE_NAME | Always returns an empty string. |
For more information, see SQLColAttributes in the ODBC Programmer's Reference.