"Tom Parke" <[EMAIL PROTECTED]> wrote: > Using sqlite3_prepare and then sqlite3_step() ing through the records, > is there a way to update or replace the current record in a table while > sqlite3_step() is on that record without a reselecting that record and > sqlite3_exec() update table where? Something like a dynamic cursor in > MS SQL? >
The "current record" might not (often does not) correspond to any row of any table. What if, for example, your query is a join or especially a join with subqueries in the FROM clause? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------