>>>It's a bug that was fixed in VFP8. You cannot get correct @@ROWCOUNT value with separate select. You may create a stored procedure witrh those 2 commnads and call it from VFP. Even better, you can return @ROWCOUNT as output parameter in that case. See
Re: Can stored procedures return values? Message #
876903.
>>
>>Thanks for you help.
>
>I think I was not clear. It's a bug that UPDATE + SELECT don't return cursor in VFP7 and eirlier. However, you cannot get correct @@ROWCOUNT value with separate select in any VFP version. And that's not a VFP bug.
I understood that. I found that @@ROWCOUNT returns the last count which is why I wanted to pass it in as a batch.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers