Brown, Dave wrote:
Is there any way to SELECT out the row number of returned results in a [...]
I want this to result in the following being added to tableB: Value | Ordering ---------------- 5 1 8 2 9 3 ....etc....
Any ideas?
-Dave
I think you should register a new functions for doing that. Look at http://www.sqlite.org/capi3ref.html#sqlite3_create_function and some samples in func.c
Paolo
