[R] RSQLite: Tracking an error message to its source

Hadley Wickham h.wickham at gmail.com
Sun Jan 5 16:12:45 CET 2014

> 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 name is
> required.

I think you've misinterpreted what database name means in this context
- sqlite only has one database per file called "main". You can attach
others using the ATTACH command



More information about the R-help mailing list