ODBC_SQLGetFunctions

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLGetFunctions (connectionID; functionIdentifier; infoValuePtr) Longint

ParameterTypeDescription
connectionIDLongintConnection ID
functionIdentifierLongintFunction identifier
infoValuePtrPointerIndicates if a function is supported or not by the driver
Function resultLongintReturns the result of the MS ODBC API function
SQLGetFunctions

Description

The ODBC_SQLGetFunctions 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:

ConstantValue
SQL_API_SQLALLOCCONNECT1
SQL_API_SQLALLOCENV2
SQL_API_SQLALLOCHANDLE1001
SQL_API_SQLALLOCSTMT3
SQL_API_SQLBINDCOL4
SQL_API_SQLBINDPARAM1002
SQL_API_SQLCANCEL5
SQL_API_SQLCLOSECURSOR1003
SQL_API_SQLCOLATTRIBUTE6
SQL_API_SQLCOLUMNS40
SQL_API_SQLCONNECT7
SQL_API_SQLCOPYDESC1004
SQL_API_SQLDATASOURCES57
SQL_API_SQLDESCRIBECOL8
SQL_API_SQLDISCONNECT9
SQL_API_SQLENDTRAN1005
SQL_API_SQLERROR10
SQL_API_SQLEXECDIRECT11
SQL_API_SQLEXECUTE12
SQL_API_SQLFETCH13
SQL_API_SQLFETCHSCROLL1021
SQL_API_SQLFREECONNECT14
SQL_API_SQLFREEENV15
SQL_API_SQLFREEHANDLE1006
SQL_API_SQLFREESTMT16
SQL_API_SQLGETCONNECTATTR1007
SQL_API_SQLGETCONNECTOPTION42
SQL_API_SQLGETCURSORNAME17
SQL_API_SQLGETDATA43
SQL_API_SQLGETDESCFIELD1008
SQL_API_SQLGETDESCREC1009
SQL_API_SQLGETDIAGFIELD1010
SQL_API_SQLGETDIAGREC1011
SQL_API_SQLGETENVATTR1012
SQL_API_SQLGETFUNCTIONS44
SQL_API_SQLGETINFO45
SQL_API_SQLGETSTMTATTR1014
SQL_API_SQLGETSTMTOPTION46
SQL_API_SQLGETTYPEINFO47
SQL_API_SQLNUMRESULTCOLS18
SQL_API_SQLPARAMDATA48
SQL_API_SQLPREPARE19
SQL_API_SQLPUTDATA49
SQL_API_SQLROWCOUNT20
SQL_API_SQLSETCONNECTATTR1016
SQL_API_SQLSETCONNECTOPTION50
SQL_API_SQLSETCURSORNAME21
SQL_API_SQLSETDESCFIELD1017
SQL_API_SQLSETDESCREC1018
SQL_API_SQLSETENVATTR1019
SQL_API_SQLSETPARAM22
SQL_API_SQLSETSTMTATTR1020
SQL_API_SQLSETSTMTOPTION51
SQL_API_SQLSPECIALCOLUMNS52
SQL_API_SQLSTATISTICS53
SQL_API_SQLTABLES54
SQL_API_SQLTRANSACT23

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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetfunctions.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next