Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec Update and number of rows
Message
From
10/05/2016 02:28:07
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01636071
Message ID:
01636077
Views:
65
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform