On Fri, Nov 15, 2013 at 10:15 AM, RSmith <rsm...@rsweb.co.za> wrote:
> > Now disregarding all the above - The very only reason you would use the > WITHOUT ROWID optimization on any table is precisely because you are NOT > using an integer primary key but because you are adding proper text values > as the Primary key, so even if you could use the last_insert function to > get a valid rowid then it won't help you because the table is referenced > via text primary key and there is nothing useful the linked table can do > woth the last_insert value... unless you are linking tables to each other > using the actual rowid, which would be the very worst DB decision ever, so > I'm sure that is not the case. > > This is the paragraph that made the light turn on. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users