On 29 May 2010, at 1:19am, Jim Terman wrote: > CREATE VIEW phonebook_order AS SELECT first_name, last_name, > phone_number FROM phonebook ORDER BY last_name, first_name; > > Now on the table phonebook I can do a query: > > SELECT rowid FROM phonebook where last_name = "Smith" and first_name = > "John"; > > which will gave me the row number of John Smith. > > How do I do this for the view phonebook_order?
Never depend on a rowid field you do not create yourself. Although you know SQLite creates them internally do not depend on them. So equip phonebook with an explicit INTEGER PRIMARY KEY AUTOINCREMENT field called, perhaps, id and use that where you want it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users