Displaying 1 result from an estimated 1 matches for "sourcesystemid".
2012 Nov 07
0
RODBC to MS SQL Server update error
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;'...