Displaying 2 results from an estimated 2 matches for "sqlitewritetable".
2005 Oct 27
2
RSQLite problems
...931 University Farm\n
2 48.86667 Manchuria 1931 Waseca\n
3 27.43334 Manchuria 1931 Morris\n
> barley$site <- as.character (barley$site)
> barley$site[1] <- "University, Farm"
> dbWriteTable (db, "barley", barley, overwrite = TRUE)
Error in sqliteWriteTable(conn, name, value, ...) :
RS-DBI driver: (RS_sqlite_import: /tmp/RtmpgSNaLn/rsdbi6a5d128c line 1
expected 5 columns of data but found 6)
I'm using RSQLite 0.4.0 with R 2.1.1 on Mac OS X.
Cheers,
Michael
2004 Dec 04
2
write.table inconsistency (PR#7403)
...,"3"
4,"4"
5,"5"
6,"6"
7,"7"
8,"8"
9,"9"
10,"10"
Notice that column "a" has a leading space in the second example, but
not the first.
Normally this won't matter, but RSQLite uses write.table in the
sqliteWriteTable function, which would cause column "a" above to be
treated as text rather than numeric, and be sorted as text rather than
into numerical order.
Duncan Murdoch