>>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.
--sb--