Howdy Matthias!
The delete operation will set the rowcount member of your cursor.
Let's assume you have an sqlite3 database with a table called 'test'
with an id column. It does have a record with id=1. It does not have
a record with id=2.
Quote:
Quote:
Quote:
>>import sqlite3
>>connection = sqlite3.connect('test.sqlite3')
>>cursor = connection.cursor()
>>cursor.execute('delete from test where id=1')
<sqlite3.Cursor object at 0x7f3450>
Quote:
Quote:
Quote:
>>print cursor.rowcount
1
Quote:
Quote:
Quote:
>>cursor.execute('delete from test where id=2')
<sqlite3.Cursor object at 0x7f3450>
Quote:
Quote:
Quote:
>>print cursor.rowcount
0
Quote:
Quote:
Quote:
>>cursor.close()
>>connection.close()
--gordy
