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