By a "regular update statement", I assume you mean a SQL update tab set col = value, but I don't understand how to apply a SQL update statement to a ROWID. How can I get the ROWID in the call back?
Can you point me to some sample code that could help me understand? Tom -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 5:50 PM To: SQLite Subject: [sqlite] Re: Update current record 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? No. You have to issue a regular update statement using current record's ROWID in the WHERE clause. Igor Tandetnik ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
