How can we get the number of rows affected by the executed UPDATE query?
r <- sqlQuery(channel, 'UPDATE foo SET bar = 1')
What I get (from a connection to a MS SQL Server DB) is just a character(0)...
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
From the Microsoft Data Access SDK ODBC Help guide:
SQLRowCount returns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an SQL_ADD, SQL_UPDATE_BY_BOOKMARK, or SQL_DELETE_BY_BOOKMARK operation in SQLBulkOperations; or an SQL_UPDATE or SQL_DELETE operation in SQLSetPos.
I expect that there is a way to invoke this ODBC function via the api you are using.
