PATCH: update of non existing row returns {error,"No SQL-driver information available."}
Paul Oliver
puzza007@REDACTED
Tue Nov 24 12:02:52 CET 2009
Hi all,
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>
Cheers,
Paul.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: odbcserver.diff
Type: text/x-diff
Size: 1687 bytes
Desc: not available
URL: <http://erlang.org/pipermail/erlang-patches/attachments/20091124/cd2ea3db/attachment.bin>
More information about the erlang-patches
mailing list