freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Update statement & SQL_NO_DATA

From: Raju Mohanapu <rmohanapu AT nyx.com>
To: "James K. Lowden" <jklowden AT freetds.org>
Cc: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Update statement & SQL_NO_DATA
Date: Tue, 27 Jan 2009 18:27:33 +0000

SQLRowCount does not interrogate the server. It returns information the
driver already has. The server included the rowcount in the DONE packet
it sent to indicate the command was successfully completed.
SQLRowCount is also the only portable way to learn the rowcount, zero or
nonzero. :-)

Thank you folks for prompt replies. I'm relieved that SQLRowCount doesn't hit the db server.

Thanks
Raju

HTH.
--jkl

[freetds] Update statement & SQL_NO_DATA, Raju Mohanapu, 01/26/2009
- Re: [freetds] Update statement & SQL_NO_DATA, James K. Lowden, 01/26/2009
  - Re: [freetds] Update statement & SQL_NO_DATA, Sebastien FLAESCH, 01/27/2009
  - Re: [freetds] Update statement & SQL_NO_DATA, Raju Mohanapu, 01/27/2009