>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.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers