Re: [pysqlite] [3.6.3-r1] Row not updated?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fred wrote:
> I forgot that path, and thought it could be some issue with the way 
> APSW handles execution (eg. the need to list() a SELECT before 
> re-using the connection led me to wrongly suspect this)

You have to list() any iterator in Python if you intend to reuse it (btw
 it was a cursor not a connection).  The same applies to pysqlite
cursors.  pysqlite does have a fetchall method, but behind the scenes
all it is doing is the list() for you!

APSW does have tracers which would have helped you:

 http://apsw.googlecode.com/svn/publish/execution.html#execution-tracer

At the moment you have to install them on each cursor.  I'll enhance the
next release so that you can install them on the connection as well to
trace all cursors.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkkmg6wACgkQmOOfHg372QS94ACgogEyCiKYugJvQFdkE6iyJ8KK
NF0Anjb5oRAKZ7aEC1br0hFplll9cjFl
=p0Qq
-----END PGP SIGNATURE-----