To All,

I've just stumbled across the ODBC SQLRowCount() function, but I'm not sure how to call it from VFP. Yes, I did RTM, but I still can't figure it out.

I tried
m.lnTally = SQLRowCount()
but of course VFP doesn't recognize that function.

I tried
m.lnTally = SQLExec(, "SQLRowCount()")
and I got an ODBC error: "Syntax error: expected something between the beginning of the request and the word 'SQLRowCount'"

Has anyone been able to successfully use this ODBC function?

Regards,
Thom C.