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

Gerhard Häring <[email protected]> Thu, 20 Nov 2008 14:29:28 +0100
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
Fred wrote:
> More information : Although the UPDATE seems 
> successfully run since the following SELECT does 
> return the correct updated value... but this 
> UPDATE is lost when I re-open the database file using sqlite3.exe afterward.
> 
> Could it be that the INSERT statements that 
> follow the UPDATE somehow supersede the previous UPDATE?

Hmm.

> 
> 	cursor.execute("END")

It's

BEGIN
...
COMMIT (make changes permanent)

or

BEGIN
...
ROLLBACK (throw changes away)

There's no BEGIN ... END in SQL.

Maybe that's the explanation.

-- Gerhard