PATCH: update of non existing row returns {error,"No SQL-driver information available."}

Paul Oliver <>
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: 1686 bytes
Desc: not available
URL: <http://erlang.org/pipermail/erlang-patches/attachments/20091124/cd2ea3db/attachment.bin>


More information about the erlang-patches mailing list