Is this a bug:
Trying to update when the where condition gives zero rows throws an error on MS
SQL server
> sqlQuery(pipe,"select * from ComDetailCurrent where RateTypeId is
null;")
[1] ProcessDate SourceSystemId AccountNumber Xref1
<0 rows> (or 0-length row.names)
sqlQuery(pipe,"update ComDetailCurrent set RateTypeId=1 where RateTypeId is
null;")
[1] "[RODBC] ERROR: Could not SQLExecDirect 'update ComDetailCurrent
set RateTypeId=1 where RateTypeId is null;'"
On the other hand with MySQL> sqlQuery(mys,"update rate_hist set val=5.0 where
dtend<'1986-05-01'")
[1] "No Data"
Please, try to update a table on SQL server and give it a where condition such
that zero rows will be updated. And post the result on this forum :-)
Thanks everybody and have a great day.
Stephen B
