|
API Special Characteristics Advantage ODBC Driver |
|
|
|
API Special Characteristics Advantage ODBC Driver |
|
|
SQL Statement Limitations
The Advantage ODBC Driver applies the following restrictions to SQL statements:
| • | Maximum of 255 characters in a table and index names. |
| • | Maximum of 128 characters in column names |
| • | Maximum of 128 characters in index names |
| • | Maximum of 20 Columns in ORDER BY |
| • | Maximum of 15 Columns in index |
| • | Maximum of 255 Database name length |
Database API Parameters
There are several API parameters that may be sent with SQLGetInfo() to return information specific to the Advantage Database Server. The constants and return values are described below:
InfoType |
Return Value |
SQL_DATABASE_NAME |
Long pointer to the current table qualifier. This may be in the form of drive:directory (e.g., as in the ODBC Administrator, like "C:\XISAM\DATA" ) or any other table qualifier (e.g., ""[c:]"\data]"). For more information on table qualifiers, see Advantage SQL Engine. |
SQL_DBMS_NAME |
"Advantage" |
SQL_DBMS_VER |
Current version |
SQL_DRIVER_NAME |
"ADSODBC.DLL" |
SQL_QUALIFIER_NAME_SEPARATOR |
"\" |
SQL_QUALIFIER_TERM |
"DIRECTORY" |
SQL_SEARCH_PATTERN_ESCAPE |
"\" |
SQL_SERVER_NAME |
"Advantage" or "ADSODBC.DLL" |