Because I need to insert them into the 2nd table as the result of a select, not first retrieve them all into my program, then loop over the results and insert into the 2nd table.
-Dave -----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 9:16 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to get row numbers in a query? > So I guess I have to write my own function, "current_row()", using the > sqlite3_create_function() APIs? If you've got a program handling this why don't you just count them as you retrieve them?