MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

SQLColAttributes

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.