Hello
Does anybody know how to call ODBC API from ODBC manager.I was
trying to work with ODBCAPI program which was downloaded from Software
download corner of UT. I had tried to execute some function from VFP and
getting error as -.2125E+10. I had done the following step to execute an
statement from VFP to ORACLE.
DECLARE INTEGER SQLExecDirect IN odbc32.dll ;
INTEGER nHstmt, ;
STRING cSqlStr, ;
INTEGER nSqlStrSize
gnConHandle=SQLCONNECT('oracle')
gnInternalConHandle = SQLGETPROP(gnConHandle,'ODBChdbc')
gnInternalStmHandle = SQLGETPROP(gnConHandle,'ODBChstmt')
cSql='SELECT * FROM Emp')
nSql=LEN(cSql)
?SQLExecDirect(gnInternalStmHandle,cSql,nSql)
I will be thankful, if anybody can provide me a sample programs do
work with ODBC functions.
Thank Q
Waheed
email:
mbws@batelco.com.bh