| title | SQLGetInfo (dBASE Driver) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.reviewer | |||
| ms.technology | connectivity | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 42ffdc9c-281b-4df5-ac6d-7b34f15ecd4c | ||
| author | David-Engel | ||
| ms.author | v-daenge |
Note
This topic provides dBASE Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
SQLGetInfo supports the SQL_FILE_USAGE information type. The returned value is a 16-bit integer that indicates how the driver directly treats files in a data source:
-
SQL_FILE_NOT_SUPPORTED - The driver is not a single-tier driver.
-
SQL_FILE_TABLE - A single-tier driver treats files in a data source as tables.
-
SQL_FILE_QUALIFIER - A single-tier driver treats files in a data source as a qualifier.
The ODBC driver returns SQL_FILE_TABLE because each file is a table.
SQL_AT_ADD_COLUMN | SQL_AT_DROP_COLUMN
| ISAM | Version | Format of version numbers |
|---|---|---|
| DBASE | 3.0 | 03.00.0000 |
| 4.0 | 04.00.0000 | |
| 5.0 | 05.00.0000 |
SQL_DL_CREATE_INDEX
SQL_DL_DROP_INDEX
SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION | SQL_QU_INDEX_DEFINITION
SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_MONTH | SQL_FN_TD_SECOND | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR