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