Displaying 1 result from an estimated 1 matches for "creditladderdata".
2010 May 20
0
RODBC: sqlSave leave primary key and other columns null
...error:
> sqlSave( ch, result, tablename=thetablename, append=TRUE,
rownames=FALSE, colnames=FALSE )
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :
missing columns in 'data'
Enter a frame number, or 0 to exit
1: sqlSave(ch, result, tablename = "CreditLadderData", append = TRUE,
rownames
2: sqlwrite(channel, tablename, dat, verbose = verbose, fast = fast, test
= te
3: odbcUpdate(channel, query, mydata, coldata[m, ], test = test, verbose =
ver
Selection: 0
When I explore a little, I see that odbcUpdate is automatically looking
for ALL the columns...