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
