[R] RODBC sqlSave Error
Christian Schulz
ozric at web.de
Wed Jan 29 23:34:02 CET 2003
Hi,
i get error after using a data.frame with subset for "sqlSave".
What can i do ?
It seems that lines like this in a data.frame structure are after subset
deleted and cause
the error ?
- attr(*, "variable.labels")= Named chr "CUSID" "Welle"
"Arbeitgeberfavorit1" "Aktuelle Bewerbungssituation" ...
..- attr(*, "names")= chr "CUSID" "WELLE" "Q21" "BEWERB" ...
sqlSave(channel,mno.x,verbose=T)
Query: CREATE TABLE mno.x (rownames varchar(255) ,BEWERB double
,MEDIENPRÄSENZ double ,GESCHLECHT double )
Error in sqlSave(channel, mno.x, verbose = T) :
[RODBC] ERROR: Could not SQLExecute
>>str(mno.x)
`data.frame': 583 obs. of 3 variables:
$ BEWERB : num 2 2 1 2 1 1 2 2 1 1 ...
$ MEDIENPRÄSENZ: num 73.3 75.0 70.0 60.0 100.0 ...
$ GESCHLECHT : num 1 1 1 1 1 1 1 1 1 1 ...
{ RODBC-1-0-1,R-1.6.2,W2k }
many thanks, christian
More information about the R-help
mailing list