I Have a number of queries to which I want to supply an incrementing column, some of these queries involve without rowid tables.
I have no control over the design of the tables. So for a table defined as: CREATE TABLE (name text, age integer) with values Steve, 34 Eric, 27 Denis, 41 I want to return a result set 1, Steve, 34 2, Eric, 27 3, Denis, 41 Is there a way of doing this with a SQL query? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users