Anatoily,
>>DECLARE SHORT SQLRowCount IN odbc32;
INTEGER StatementHandle,;
INTEGER @ RowCountPtr
Close... ever so close.
When I run it in VFP 8 I get a VFP error: "Declare DLL call caused an exception"
The call is running against a Teradata DBMS and I've verified that SQLRowCount is defined in the Teradata ODBC.
Obviously I'm doing something wrong.
Regards,
Thom C.
FWIW, here's my test code.
DECLARE SHORT SQLRowCount IN ODBC32 ;
INTEGER StatementHandle, ;
INTEGER @RowCountPtr
lhTest = SQLSTRINGCONNECT("dns=DemoTDat;")
IF lhTest > -1
lcSQL = "SELECT * FROM dbc.tables ORDER BY CreateTimeStamp"
lnResult = SQLEXEC(m.lhTest, m.lcSQL) && returns several hundred rows... obviously a good connection
lnSQLResult = SQLRowCount(m.lhTest, @lnTally) && errors out
SQLDisconnect(m.lhTest)
ENDIF
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement