4D v13

ODBC_SQLGetFunctions

Home

 
4D v13
ODBC_SQLGetFunctions

ODBC_SQLGetFunctions 


 

ODBC_SQLGetFunctions ( connectionID ; functionIdentifier ; infoValuePtr ) -> Function result 
Parameter Type   Description
connectionID  Longint in Connection ID
functionIdentifier  Longint in Function identifier
infoValuePtr  Pointer in Indicates if a function is supported or not by the driver
Function result  Longint in 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:

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 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.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Information
Number: 16988

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004