Dear list,
i have installed SQLiteDF (and SQlite 3.5.3 too)
After the suggested dataframe generation
iris.sdf <- sqlite.data.frame(iris)
i have close R and than restart it for verify the correct load of dataframe
:
the file data1 is saved in the usual folder .SQLiteDF
after the command :
attachSdf("c:/R/Report/.SQLiteDF/data1.db","iris.sdf")
R give this error
SQLITE ERROR (line 295 at sqlite_workspace.c): column internal_name is not
unique
SQLITE ERROR (line 463 at sqlite_workspace.c): near "data1": syntax error
if i try a new solution (after delete all the .SQLite folder)
iris.sdf <- sqlite.data.frame(iris)
iris.sdf1<-inameSdf(iris.sdf)
attachSdf(".SQLiteDF/iris.db","iris.sdf")
OR attachSdf(".SQLiteDF/iris.db","iris.sdf1")
the message is the same
Errore in attachSdf(".SQLiteDF/iris.db", "iris.sdf") :
.SQLiteDF/iris.db is not a valid SDF.
perhaps anyone know thi problem
thanks in advance
Roberto Iacopetti
--
View this message in context:
http://www.nabble.com/SQLiteDF-SQLITE-ERROR-after-attach-tf4962680.html#a14214520
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
