Displaying 1 result from an estimated 1 matches for "thetablename".
2010 May 20
0
RODBC: sqlSave leave primary key and other columns null
I have an existing table, and I am trying to use sqlSave to append
additional rows to this database. I omit the primary key, which is a
uniqueidentifier type (MS SQL), so that the database can populate that
field. However, I get the following 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(...