>>>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
>>
>>Unless I misunderstand your question, the return value from SqlExec() is what you are looking for.
>
>The return value is how many result sets are generated by this SQLEXEC(), not how many records are affected/fetched.
>:-)
Another possibility - it might take some work but might possibly give a better answer (especially if you want to get the tally of how many values actually changed)...slap an OUTPUT INSERTED.Column as NewVal, DELETED.Column as OldVal into SomeOutputTable at the end. That way you can capture the tally of what changed.
Kevin