community.borland.com

Article #25229: 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

Last Modified: 02-OCT-00