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

[Hadley Wickham]

> 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
(http://www.sqlite.org/lang_attach.html).

Hadley


-- 
http://had.co.nz/