Jim,

Everything I know about SqlRowCount() I learned in kindergarden...

no, that's not right...

I learned it from Anatoily Mogylevets in thread 810276

In summary,

DECLARE SHORT SqlRowCount IN ODBC32 INTEGER StatementHandle, INTEGER @RowCountPtr

*** get the "actual" handle, vs the VFP handle
m.lhActual = SQLGetProp(m.lhVFP_Handle, "ODBChstmt")

*** pass the "tally" memvar into SQLRowCount() by reference
m.lnTally = -1
SQLRowCount(m.lhActual, @lnTally)

This information, with modifications, also applies to SQLExecDirect().

Regards,
Thom C.