On Monday 20 August 2007 12:15, Ed Leafe wrote: > 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 I gather that I should disregard this error I'm getting? -- John Fabiani
_______________________________________________ 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]
