Re: Possible to determine number of rows affected by a SQLite update or delete command?

2010-11-30 Thread Kushal Kumaran
On Tue, Nov 30, 2010 at 2:29 PM, wrote: > Is there a cursor or connection property that returns the number of rows > affected by a SQLite update or delete command? > The cursor has a rowcount attribute. The documentation of the sqlite3 module says the implementation is "quirky". You might take

Possible to determine number of rows affected by a SQLite update or delete command?

2010-11-30 Thread python
Is there a cursor or connection property that returns the number of rows affected by a SQLite update or delete command? Or, if we want this information, do we have to pre-query our database for a count of records that will be affected by an operation? Thank you, Malcolm -- http://mail.python.org