On 1 Jul 2013, at 10:33am, Tony Papadimitriou <to...@acm.org> wrote:
> Is there a function (or method), e.g., row(), to return the sequence number > of the selected row? This is not the same as ROWID. row() should give a > sequence number always starting from 1 up the to the number of rows returned > by the view/select etc. Nope. It’s your software that calls _step() to get the next row. So you can keep count of that number in a variable in your software. There’s no advantage in having SQLite do it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users