>>>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.
>:-)
I clearly have a bad morning, must be the unusually warm weather we have today, right now it's 23°C. :-)