> I am addicted to using INTEGER PRIMARY KEY AUTOINCREMENT as the id > fields in my SQLite projects, yet I would like to try some triggers > as well. Of course, every time I add a trigger that accesses a > table with these types of id fields, all sorts of odd things > happen.
Not to mention the fact that an index made up of 2 or more fields including the id field won't be used correctly. See http://www.sqlite.org/cvstrac/tktview?tn=1893 Hugh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
