4D Doc Center : ODBC

Home

4D v14.1

ODBC_SQLNativeSql


ODBC_SQLNativeSql ( connectionID ; inStatementText ; outStatementText ) -> Function result

Parameter	Type	Description
connectionID	Longint	Connection ID
inStatementText	Text	SQL text string to be translated
outStatementText	Text	Translated SQL string
Function result	Longint	Returns the result of the MS ODBC API function SQLNativeSql

The ODBC_SQLNativeSql command returns the SQL string as modified by the driver but does not execute the SQL statement.

connectionID is a valid connection ID returned by ODBC_SQLAllocConnect and a connection must be established using the ODBC_SQLConnect command.

inStatementText is the SQL text string to be translated.

outStatementText is the translated SQL string.

For more information, please see the SQLNativeSql function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms714575(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.