I am new to client/server stuff so I am trying to learn on the fly. So am asking questions that are probably no-brainers to many of you. After you run a pass through "Select" query using SQLEXEC creating a result cursor, what is the best way to obtain the number of records selected from the Server immediately afterwards. I know there is a SQL Server function called "SQLRowCount" but I don't know how to access it from VFP 7. I know I could do a Reccount() on the cursor created by my select statement but I am looking for alternative methods.

How do you run functions and obtain the values of variables only available on the SQL server side and not native to VFP anyways? I only figured out how to access the tables & run SQL queries against them as of now.

I want to use VFP and not ASP or PHP