Example of how to use SQLNativeSql

Abstract: Example of how to use SQLNativeSql

Problem: Don't know how to use SQLNativeSql function call in ODBC SDK. Solution: IB V4.x Visigenic InterBase ODBC driver SQLNativeSql returns SQL strings translated by the driver. This function call can use to workaround UNION when the driver doesn't support unions. This is an example of how to use the SQLNativeSql function in ODBCTest: 1) Make a connection to a database 2) Enter a SQL statement in the input window ( top window) 3) Run SQLAllocStmt 5) Run SQLNativeSql 6) Run SQLExecDirect 6) Run GetDataAll