On Sat, 29 May 2010 02:35:22 +0100, Simon Slavin <slav...@bigfraud.org> wrote:
>On 29 May 2010, at 2:30am, Jim Terman wrote: > >> I want the 'rowid' of the view. In other words I'd like to now what row >> John Smith is in the view. I can do it with a view that is ordered by >> using count(*), but I wondered if there was a better way. > I believe that a view is just a window into an existing table: > a way of saving the terms of a 'SELECT' statement so you > don't have to keep restating it. Therefore it has no data > of its own, including no rowids of its own. That's correct. > Try doing 'SELECT rowid FROM phonebook_order' and see > whether you get any result at all, and whether the numbers are in order. I like the way you invite people to experiment themselves. It's the best way to acquire knowledge. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
