>Hi,
>
>When I execute an UPDATE command in the SSMS I see in the message areas of "so many rows affected". How can I get this number when executing the UPDATE from the VFP SQLExec() function? I tried adding a parameter, variable, to the SQLExec() hoping that it would return a cursor containing the number of affected rows. But it didn't work.
>Can it be done?
>TIA
Add
select @@ROWCOUNT as RecordsAffected;
after your update command (as part of the same command), then you'll get that number into a cursor.
If it's not broken, fix it until it is.
My Blog