Wayne,
< update...just saw you are using SQLEXEC...>
I was going to suggest _tally...
>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
Steve Gibson