RE: [sqlite] SQL to renumber values in a column?

Hi Dave If you query the database with order by, the result sequence is the order you are looking for, so you donot need to update at all. Like: select * from table order by order_number Row 1: a, 1 Row 2: c, 3 Row 3: d, 4 The result-set row number is the order you are looking for. Regards.

RE: [sqlite] SQL to renumber values in a column?

That's not what I want, though. I want to UPDATE the actual values in the order_number column so they end up as 1, 2, 3 instead of 1, 3, 4. So I want the result of a "select * from table order by order_number" to give me: a, 1 c, 2 d, 3 -Dave -Original Message- From: Dong

Re: [sqlite] request for additions to sqlite 3.xx

basil thomas wrote: As for storing queries, I'm not sure how useful this feature is given that the database engine itself is part of your program. For simple queries your best bet is a static sqlite3_stmt object, which you prepare once at program initiation and refer back to each time it is