[R] SQLiteDF SQLITE ERROR after attach

[Roberto Iacopetti]

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.