SQL_NO_DATA and SQLSTATE 00000 indicate success for updates/deletes that affect no rows

I noticed the following when no rows were updated for an update statement:

4> odbc:param_query(Ref, "update tbadger set status = ? where
badger_id = ?", [{{sql_varchar,1},["R"]},    {sql_integer, [61111]}]).
{error,"No SQL-driver information available."}
5> odbc:param_query(Ref, "update tbadger set status = ? where
badger_id = ?", [{{sql_varchar,1},["R"]},    {sql_integer, [61]}]).
{updated,1}

The attached patch, which requires the ODBC patch from Andrew
Thompson, should fix it:

3> odbc:param_query(Ref, "update tbadger set status = ? where
badger_id = ?", [{{sql_varchar,1},["R"]},    {sql_integer, [61111]}]).
{updated,0}
4>

I've followed the advice given on MSDN
(http://msdn.microsoft.com/en-us/library/ms715424%28VS.85%29.aspx) and
checked for SQL_NO_DATA combined with SQLSTATE 000000

0 files changed, 0 insertions, 0 deletions