>Hi,
>
>I am calling SQL Update command from VFP application. Since I don't know if the matching record is found in the SQL Server, I want to have the results; so that I can count how many record were updated. I thought I can add the name of a cursor and "capture" this. But it does not seem to work. Here is what I am doing:
>
>

>cSqlUpdate = "update mytable set field1 = '1233' where id_field = 'ABC'"
>nResult = SQLEXEC(hCon, cSqlUpdate, "cur_result")
>

>
>I thought that the cursor "cur_result" would be created on successful update. But Select ("cur_result") is 0 after an update that I see worked. What am I missing?
>
>TIA
>

UPDATE statement do not create cursor.