On Sun, Jan 5, 2014 at 7:12 AM, Hadley Wickham wrote:
> > Though I admit that it bothers me that, although the SQLite syntax
> > documentation for "CREATE INDEX", here:
> > http://www.sqlite.org/lang_createindex.html
> > does say the database name is optional, it also says that, if you
> include
> Though I admit that it bothers me that, although the SQLite syntax
> documentation for "CREATE INDEX", here:
> http://www.sqlite.org/lang_createindex.html
> does say the database name is optional, it also says that, if you include
> it, the period the period between the db name and the table nam
> Can you, or anyone, give me any hint on where -- no, not where, _how_ -- to
> find the code for any of the functions called between dbGetQuery method for
> conn="SQLiteConnection", or for any of the functions that are called by the
> dbGetQuery method for SQLite connections that are in the chain
I recommend that you NOT try to go down that particular rabbit hole unless you
are very confident in your computer science skills... database engines are very
complicated. Learn to work with the error messages provided to you, and think
in SQL when working with a SQL database.
--
Thanks, Ista! That did the job.
Though I admit that it bothers me that, although the SQLite syntax
documentation for "CREATE INDEX", here:
http://www.sqlite.org/lang_createindex.html
does say the database name is optional, it also says that, if you include
it, the period the period between the db
dbGetQuery doesn't like the "." in your index name. Change to
something else, e.g.,
command <-paste("CREATE INDEX IF NOT EXISTS ", DBname_c, "_",
indexName_c, " ON ", yourTable_c, " (",
paste(indexVars_C, collapse=", "), ")", sep='')
}
Best,
Ista
On Sa
Andrew Hoerner rprogress.org> writes:
>
> Dear folks--
> I am not sure if this should be framed as a question about RSQLite, about
> debugging, about SQLite, or about how to write a good question. I have a
> little function (copied below beneath the error messages along with my
> data), that is
Dear folks--
I am not sure if this should be framed as a question about RSQLite, about
debugging, about SQLite, or about how to write a good question. I have a
little function (copied below beneath the error messages along with my
data), that is supposed to read a csv file and write it out to SQLit
8 matches
Mail list logo
