Displaying 1 result from an estimated 1 matches for "rate_hist".
Did you mean:
rate_est
2012 Nov 07
0
RODBC to MS SQL Server update error
...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