#define SQL_OPT_TRACE 104 #define SQL_OPT_TRACEFILE 105 #define SQL_IS_INTEGER (-6) DECLARE integer SQLSetConnectAttr in odbc32.dll integer, integer, string @, integer DECLARE integer SQLSetConnectAttr in odbc32.dll AS SQLSetConnectAttrI integer, integer, integer, integer LOCAL lihdbc,liHODBC,liLen,liPom liLen=0 lihdbc=SQLSTRINGCONNECT(".....") liHODBC=SQLGETPROP(lihdbc,"ODBChdbc") lcPom="E:\trace.log" =SQLSetConnectAttr(liHODBC, SQL_OPT_TRACEFILE, @lcPom, LEN(lcPom)) liPom=1 =SQLSetConnectAttrI(liHODBC, SQL_OPT_TRACE, liPom, SQL_IS_INTEGER) =SQLEXEC(lihdbc,"SELECT XX002,XX003 FROM XXT004I WHERE XX000=2") liPom=0 =SQLSetConnectAttrI(liHODBC, SQL_OPT_TRACE, liPom, SQL_IS_INTEGER) =SQLDISCONNECT(lihdbc)MartinaJ
>myVar = "test" >mySql = "select * from myTable where someField=?myVar" >=sqlExec( Handle, mySql ) >>