> I've banged on about this problem and thanks to your assistance it > seems > to be resolved now. Perhaps you could update the documentation at > http://www.sqlite.org/autoinc.html and > http://www.sqlite.org/lang_createindex.html - I had certainly read > these many times so a note about rowid's role would be very helpful > and prevent further annoying questions in the mailing list ;-). I've > added a note to ticket 1893.
Just a reminder about this. Could a note be added to those two pages that the ROWID field is added implicitly to the end of every index, therefore don't explicitly include the ROWID field in any index. See http://www.sqlite.org/cvstrac/tktview?tn=1893,5 Hugh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users