On Aug 20, 2007, at 2:34 PM, johnf wrote:
> this is coming from dPref.py
> if not crs.rowcount:
> sql = "insert into daboprefs (ckey, ctype, cvalue)
> values
> (?, ?, ?)"
> prm = (key, typ, val)
> crs.execute(sql, prm)
> self._cursor.commitTransaction()
>
> Is the self._cursor.commitTransaction() required in this case
> (SQLite)? Does
> SQLite issue it's own commit?
SQLite is one of the backends that require this extra commit. It
implicitly starts a transaction when you execute a data-modifying
statement, and will discard that change if you do not issue a commit.
Hint: that's what the old 'AutoCommit' property was for.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
