MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

SQLGetInfo

Support: Full  
ODBC API Conformance: Level 1

Returns general information about the Visual FoxPro ODBC Driver and data source associated with a connection handle, hdbc. The following list shows the value returned by the Visual FoxPro ODBC Driver for each fInfoType argument and comments regarding the returned values.

For more information, see SQLGetInfo in the ODBC Programmer's Reference.

A

SQL_ACCESSIBLE_PROCEDURES returns 'N'.

SQL_ACCESSIBLE_TABLES returns 'Y'.

SQL_ACTIVE_CONNECTIONS returns 0.

SQL_ACTIVE_STATEMENTS returns 0.

SQL_ALTER_TABLE returns either SQL_AT_ADD_COLUMN or SQL_AT_DROP_COLUMN.

B

SQL_BOOKMARK_PERSISTENCE returns SQL_BP_SCROLL.

C

SQL_COLUMN_ALIAS returns 'Y'.

SQL_CONCAT_NULL_BEHAVIOR returns SQL_CB_NULL.

SQL_CONVERT_BIGINT returns 0. The Visual FoxPro ODBC Driver does not support BigInt.

SQL_CONVERT_BINARY returns 0.

SQL_CONVERT_BIT returns 0.

SQL_CONVERT_CHAR returns 0.

SQL_CONVERT_DATE returns 0.

SQL_CONVERT_DECIMAL returns 0.

SQL_CONVERT_DOUBLE returns 0.

SQL_CONVERT_FLOAT returns 0.

SQL_CONVERT_INTEGER returns 0.

SQL_CONVERT_LONGVARBINARY returns 0.

SQL_CONVERT_LONGVARCHAR returns 0.

SQL_CONVERT_NUMERIC returns 0.

SQL_CONVERT_REAL returns 0.

SQL_CONVERT_SMALLINT returns 0.

SQL_CONVERT_TIME returns 0.

SQL_CONVERT_TIMESTAMP returns 0.

SQL_CONVERT_TINYINT returns 0.

SQL_CONVERT_VARBINARY returns 0.

SQL_CONVERT_VARCHAR returns 0.

SQL_CONVERT_FUNCTIONS returns 0.

SQL_CORRELATION_NAME returns SQL_CN_ANY.

SQL_CURSOR_COMMIT_BEHAVIOR returns SQL_CB_PRESERVE.

SQL_CURSOR_ROLLBACK_BEHAVIOR returns SQL_CB_PRESERVE.

D

SQL_DATA_SOURCE_NAME returns the value passed as DSN to SQLConnect, or SQLDriverConnect; returns an empty string if no DSN is specified.

SQL_DATA_SOURCE_READ_ONLY returns 'N'.

SQL_DATABASE_NAME returns a full UNC path to the current database if the data source is a database. If the data source connects to a directory of tables, the function returns the path to the directory.

SQL_DBMS_NAME returns "Visual FoxPro".

SQL_DBMS_VER returns "03.00.0000".

SQL_DEFAULT_TXN_ISOLATION returns SQL_TXN_READ_COMMITTED. Dirty reads are not possible, but nonrepeatable reads and phantoms are possible.

SQL_DRIVER_HDBC is implemented by the Driver Manager.

SQL_DRIVER_HENV is implemented by the Driver Manager.

SQL_DRIVER_HLIB is implemented by the Driver Manager.

SQL_DRIVER_HSTMT is implemented by the Driver Manager.

SQL_DRIVER_NAME  returns "vfpodbc.dll".

SQL_DRIVER_ODBC_VER returns "02.50" (SQL_SPEC_MAJOR, SQL_SPEC_MINOR).

SQL_DRIVER_VER returns "01.00.0000".

E

SQL_EXPRESSIONS_IN_ORDERBY returns 'N'.

F

SQL_FETCH_DIRECTION returns:

SQL_FD_FETCH_NEXT
SQL_FD_FETCH_FIRST
SQL_FD_FETCH_LAST
SQL_FD_FETCH_PRIOR
SQL_FD_FETCH_ABSOLUTE
SQL_FD_FETCH_RELATIVE
SQL_FD_FETCH_BOOKMARK.

SQL_FILE_USAGE returns SQL_FILE_QUALIFIER both for database (.dbc file) and for free table (.dbf file) data sources.

G-H

SQL_GETDATA_EXENSIONS returns:

SQL_GD_ANY_COLUMN
SQL_GD_ANY_BLOCK
SQL_GD_ANY_BOUND
SQL_GD_ANY_ORDER

SQL_GROUP_BY returns SQL_GB_NO_RELATION.

I-J

SQL_IDENTIFIER_CASE returns SQL_IC_MIXED.

SQL_IDENTIFIER_QUOTE_CHAR returns `.

K

SQL_KEYWORDS returns "".

L

SQL_LIKE_ESCAPE_CLAUSE returns 'N'.

SQL_LOCK_TYPES returns SQL_LCK_NO_CHANGE.

M

SQL_MAX_BINARY_LITERAL_LEN returns 0.

SQL_MAX_CHAR_LITERAL_LEN returns 254.

SQL_MAX_COLUMN_NAME_LEN returns 128.

SQL_MAX_COLUMNS_IN_GROUP_BY returns 16.

SQL_MAX_COLUMNS_IN_ORDER_BY returns 16.

SQL_MAX_COLUMNS_IN_INDEX returns 0.

SQL_MAX_COLUMNS_IN_SELECT returns 254.

SQL_MAX_COLUMNS_IN_TABLE returns 254.

SQL_MAX_CURSOR_NAME_LEN returns 254.

SQL_MAX_INDEX_SIZE returns 0.

SQL_MAX_OWNER_NAME_LEN returns 0.

SQL_MAX_PROCEDURE_NAME_LEN returns 0. The Visual FoxPro ODBC Driver does not allow direct access to Visual FoxPro stored procedures.

SQL_MAX_QUALIFIER_NAME_LEN returns the maximum operating system path length.

SQL_MAX_ROW_SIZE returns 254^2.

SQL_MAX_ROW_SIZE_INCLUDES_LONG returns 'N'.

SQL_MAX_STATEMENT_LEN returns 8192.

SQL_MAX_TABLE_NAME_LEN returns 128.

SQL_MAX_TABLES_IN_SELECT returns 16.

SQL_MAX_USER_NAME_LEN returns 0.

SQL_MULT_RESULT_SETS returns 'Y'.

SQL_MULTIPLE_ACTIVE_TXN returns 'Y'. Multiple connections can have several transactions open at once.

N

SQL_NEED_LONG_DATA_LEN returns 'N'.

SQL_NON_NULLABLE_COLUMNS returns SQL_NNC_NON_NULL.

SQL_NULL_COLLATION returns SQL_NC_LOW.

SQL_NUMERIC_FUNCTIONS returns all functions except SQL_FN_NUM_POWER, which is not supported by the Visual FoxPro ODBC Driver. The following functions are supported:

SQL_FN_NUM_ABS
SQL_FN_NUM_ACOS
SQL_FN_NUM_ASIN
SQL_FN_NUM_ATAN
SQL_FN_NUM_ATAN2
SQL_FN_NUM_CELING
SQL_FN_NUM_COS
SQL_FN_NUM_COT
SQL_FN_NUM_DEGREES
SQL_FN_NUM_EXP
SQL_FN_NUM_FLOOR
SQL_FN_NUM_LOG
SQL_FN_NUM_LOG10
SQL_FN_NUM_MOD
SQL_FN_NUM_PI
SQL_FN_NUM_RADIANS
SQL_FN_NUM_RAND
SQL_FN_NUM_ROUND
SQL_FN_NUM_SIGN
SQL_FN_NUM_SIN
SQL_FN_NUM_SQRT
SQL_FN_NUM_TAN

O

SQL_ODBC_API_CONFORMANCE returns SQL_OAC_LEVEL1.

SQL_ODBC_SAG_CLI_CONFORMANCE returns SQL_OSCC_COMPLIANT.

SQL_ODBC_SQL_CONFORMANCE returns SQL_OSC_MINIMUM. Minimum SQL syntax is supported.

SQL_ODBC_SQL_OPT_IEF returns "N".

SQL_ODBC_VER is implemented by the Driver Manager.

SQL_ORDER_BY_COLUMNS_IN_SELECT returns "N".

SQL_OUTER_JOINS returns "N".

SQL_OWNER_TERM returns "". The Visual FoxPro ODBC Driver does not support owners for its objects.

SQL_OWNER_USAGE returns 0. The Visual FoxPro ODBC Driver does not support owners for its objects.

P

SQL_POS_OPERATIONS returns SQL_POS_POSITION.

SQL_POSITIONED_STATEMENTS returns 0.

SQL_PROCEDURE_TERM returns "".

SQL_PROCEDURES returns 'N'.

Q

SQL_QUALIFIER_LOCATION returns SQL_QL_START.

SQL_QUALIFIER_NAME_SEPARATOR returns '!' or '\'. The separator between database and table is '!' for data sources connected to databases, and '\' for data sources that are directories of free tables.

SQL_QUALIFIER_TERM returns "database" or "directory". The qualifier is "database" for data sources connected to databases, and "directory" for data sources that are directories of free tables.

SQL_QUALIFIER_USAGE does not support SQL_QU_PRIVILEGE_DEFINITION; it returns either SQL_QU_DML_STATEMENT or SQL_QU_TABLE_DEFINITION.

SQL_QUOTED_IDENTIFIER_CASE returns SQL_IC_MIXED.

R

SQL_ROW_UPDATES returns "N". The Visual FoxPro ODBC Driver supports only static and forward cursors.

S

SQL_SCROLL_CONCURRENCY returns SQL_SCCO_READ_ONLY.

SQL_SCROLL_OPTIONS returns either SQL_SO_STATIC or SQL_SO_READONLY.

SQL_SEARCH_PATTERN_ESCAPE returns "\".

SQL_SERVER_NAME returns "".

SQL_SPECIAL_CHARACTERS returns "~@#$%^".

SQL_STATIC_SENSITIVITY returns 0. The Visual FoxPro ODBC Driver does not support positional updates.

SQL_STRING_FUNCTIONS does not support SQL_FN_STR_INSERT, SQL_FN_STR_LOCATE, SQL_FN_STR_LOCATE_2, or SQL_FN_STR_SOUNDEX.
It returns:

SQL_FN_STR_ASCII
SQL_FN_STR_CHAR
SQL_FN_STR_CONCAT
SQL_FN_STR_DIFFERENCE
SQL_FN_STR_LCASE
SQL_FN_STR_LEFT
SQL_FN_STR_LENGTH
SQL_FN_STR_LTRIM
SQL_FN_STR_REPEAT
SQL_FN_STR_REPLACE
SQL_FN_STR_RIGHT
SQL_FN_STR_RTRIM
SQL_FN_STR_SUBSTRING
SQL_FN_STR_UCASE
SQL_FN_STR_SPACE.

SQL_SUBQUERIES returns:

SQL_SQ_CORRELATED_SUBQUERIES
SQL_SQ_COMPARISON
SQL_SQ_EXISTS
SQL_SQ_IN
SQL_SQ_QUANTIFIED.

SQL_SYSTEM_FUNCTIONS returns:

SQL_FN_SYS_DBNAME
SQL_FN_SYS_IFNULL

but not:
SQL_FN_SYS_USERNAME

T

SQL_TABLE_TERM returns "table".

SQL_TIMEDATE_ADD_INTERVALS returns:

SQL_FN_TSI_ SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_MONTH
SQL_FN_TSI_YEAR

but not:

SQL_FN_TSI_FRAC_SECOND
SQL_FN_TSI_WEEK
SQL_FN_TSI_QUARTER

SQL_TIMEDATE_DIFF_INTERVALS returns:

SQL_FN_TSI_ SECOND
SQL_FN_TSI_MINUTE
SQL_FN_TSI_HOUR
SQL_FN_TSI_DAY
SQL_FN_TSI_MONTH
SQL_FN_TSI_YEAR

SQL_TIMEDATE_FUNCTIONS does not support SQL_FN_TD_QUARTER, SQL_FN_TD_TIMESTAMPADD, SQL_FN_TD_DAYOFYEAR, or SQL_FN_TD_WEEK.
It returns:

SQL_FN_TD_CURDATE
SQL_FN_TD_CURTIME
SQL_FN_TD_DAYNAME
SQL_FN_TD_DAYOFMONTH
SQL_FN_TD_DAYOFWEEK
SQL_FN_TD_HOUR
SQL_FN_TD_MINUTE
SQL_FN_TD_MONTH
SQL_FN_TD_MONTHNAME
SQL_FN_TD_NOW
SQL_FN_TD_SECOND
SQL_FN_TD_TIMESTAMPDIFF
SQL_FN_TD_YEAR .

SQL_TXN_CAPABLE returns SQL_TC_DML.

SQL_TXN_ISOLATION_OPTION returns SQL_TXN_READ_COMMITTED.

U-Z

SQL_UNION returns either SQL_U_UNION or SQL_U_UNION_ALL.

SQL_USER_NAME returns <blank>.