[R] SQLiteDF SQLITE ERROR after attach

Roberto Iacopetti iacopetti at fastpiu.it
Fri Dec 7 16:37:36 CET 2007

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 :
R give this error
SQLITE ERROR (line 295 at sqlite_workspace.c): column internal_name is not
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)


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.

More information about the R-help mailing list