>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
Check last parameter of SQLEXEC function.
[, aCountInfo]]])
aCountInfoSpecifies the name of the array to populate with row count information. If the array doesn’t exist, it is created. The array has two columns: 1 – Alias, 2 –Count.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.