Roger Binns wrote: > > The cursor object in apsw wraps a prepared statement. Since the cursor > gets reused the earlier results are no longer available: > > cursor.execute("select * from numbers") > ... > cursor.execute("delete from numbers where no=5") >
OK, that makes sense. > > Alternatively the "delete" statement can be done with a different cursor > so that the earlier one is not clobbered: > > cursor2=conn.cursor() > cursor2.execute("delete from numbers where no=5") > This is effectively what the sqlite3_exec(db, "delete....") call does internally in the C API program I posted. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users