"Tommy Benson" <tommyalph...@gmail.com> wrote in message news:a1a7fb90812201757i4aa3339ma8489161aec89...@mail.gmail.com > Is there a way to get select and update statements show to rows ids > in temporary sorted order > For example: > SELECT * FROM Persons > ORDER BY LastName DESC > > > P_Id LastName FirstName Address City 2 Svendson Tove Borgvn 23 > Sandnes 3 Pettersen Kari Storgt 20 Stavanger 4 Nilsen Tom Vingvn 23 > Stavanger 1 Hansen Ola Timoteivn 10 Sandnes > Ideally it would work like: > > Tempid LastName FirstName Address City 1 > Svendson Tove Borgvn 23 Sandnes 2 Pettersen Kari Storgt 20 Stavanger > 3 Nilsen Tom Vingvn 23 Stavanger 4 Hansen Ola Timoteivn 10 Sandnes > > Is there a way of creating this somehow?
In your application, just have a counter and increment it every time you call sqlite3_step to get the next row. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users