> 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/ ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
