4D v13
ODBC_SQLGetFunctions
ODBC_SQLGetFunctions
| ODBC_SQLGetFunctions ( connectionID ; functionIdentifier ; infoValuePtr ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| connectionID | Longint |
|
Connection ID | |||||
| functionIdentifier | Longint |
|
Function identifier | |||||
| infoValuePtr | Pointer |
|
Indicates if a function is supported or not by the driver | |||||
| Function result | Longint |
|
Returns the result of the MS ODBC API function SQLGetFunctions | |||||
The ODBC_SQLGetFunctions command allows you to determine which specific ODBC functions a driver supports.
connectionID is a valid connection ID returned by ODBC_SQLAllocConnect and a connection must be established using the ODBC_SQLConnect command.
functionIdentifier is the identifier of the function to test to see if it is supported by the driver and can be one of the values below:
| Constant | Value |
| SQL_API_SQLALLOCCONNECT | 1 |
| SQL_API_SQLALLOCENV | 2 |
| SQL_API_SQLALLOCHANDLE | 1001 |
| SQL_API_SQLALLOCSTMT | 3 |
| SQL_API_SQLBINDCOL | 4 |
| SQL_API_SQLBINDPARAM | 1002 |
| SQL_API_SQLCANCEL | 5 |
| SQL_API_SQLCLOSECURSOR | 1003 |
| SQL_API_SQLCOLATTRIBUTE | 6 |
| SQL_API_SQLCOLUMNS | 40 |
| SQL_API_SQLCONNECT | 7 |
| SQL_API_SQLCOPYDESC | 1004 |
| SQL_API_SQLDATASOURCES | 57 |
| SQL_API_SQLDESCRIBECOL | 8 |
| SQL_API_SQLDISCONNECT | 9 |
| SQL_API_SQLENDTRAN | 1005 |
| SQL_API_SQLERROR | 10 |
| SQL_API_SQLEXECDIRECT | 11 |
| SQL_API_SQLEXECUTE | 12 |
| SQL_API_SQLFETCH | 13 |
| SQL_API_SQLFETCHSCROLL | 1021 |
| SQL_API_SQLFREECONNECT | 14 |
| SQL_API_SQLFREEENV | 15 |
| SQL_API_SQLFREEHANDLE | 1006 |
| SQL_API_SQLFREESTMT | 16 |
| SQL_API_SQLGETCONNECTATTR | 1007 |
| SQL_API_SQLGETCONNECTOPTION | 42 |
| SQL_API_SQLGETCURSORNAME | 17 |
| SQL_API_SQLGETDATA | 43 |
| SQL_API_SQLGETDESCFIELD | 1008 |
| SQL_API_SQLGETDESCREC | 1009 |
| SQL_API_SQLGETDIAGFIELD | 1010 |
| SQL_API_SQLGETDIAGREC | 1011 |
| SQL_API_SQLGETENVATTR | 1012 |
| SQL_API_SQLGETFUNCTIONS | 44 |
| SQL_API_SQLGETINFO | 45 |
| SQL_API_SQLGETSTMTATTR | 1014 |
| SQL_API_SQLGETSTMTOPTION | 46 |
| SQL_API_SQLGETTYPEINFO | 47 |
| SQL_API_SQLNUMRESULTCOLS | 18 |
| SQL_API_SQLPARAMDATA | 48 |
| SQL_API_SQLPREPARE | 19 |
| SQL_API_SQLPUTDATA | 49 |
| SQL_API_SQLROWCOUNT | 20 |
| SQL_API_SQLSETCONNECTATTR | 1016 |
| SQL_API_SQLSETCONNECTOPTION | 50 |
| SQL_API_SQLSETCURSORNAME | 21 |
| SQL_API_SQLSETDESCFIELD | 1017 |
| SQL_API_SQLSETDESCREC | 1018 |
| SQL_API_SQLSETENVATTR | 1019 |
| SQL_API_SQLSETPARAM | 22 |
| SQL_API_SQLSETSTMTATTR | 1020 |
| SQL_API_SQLSETSTMTOPTION | 51 |
| SQL_API_SQLSPECIALCOLUMNS | 52 |
| SQL_API_SQLSTATISTICS | 53 |
| SQL_API_SQLTABLES | 54 |
| SQL_API_SQLTRANSACT | 23 |
infoValuePtr is a pointer to a Longint variable that will be equal to either SQL_TRUE if the specified function is supported by the driver or SQL_FALSE if it is not supported.
ODBC_SQLGetFunctions returns SQL_SUCCESS if the function executes correctly.
For more information, please see the SQLGetFunctions function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms709291(VS.85).aspx.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Product: 4D
Theme: ODBC_Information
Number:
16988
Created: 4D ODBC Pro 2004
