On Tuesday 21 August 2007 14:25, johnf wrote: > > I am confused as to the real cause of the error. In my debugging session I > found the issue to be in dPref.py with the > line "self._cursor.commitTransaction()" > > >From dPref: > > sql = "update daboprefs set ctype = ?, cvalue = ? where ckey = ? " > prm = (typ, val, key) > crs.execute(sql, prm) > # Use the dbapi-level 'rowcount' attribute to get the number > # of affected rows. > if not crs.rowcount: > sql = "insert into daboprefs (ckey, ctype, cvalue) values (?, ?, ?)" > prm = (key, typ, val) > crs.execute(sql, prm) > self._cursor.commitTransaction() > > As I read the code "crs.execute(sql, prm)" updates the db (and it in fact > it does update the data). While doing so a transaction is started. I > assume that is true from Ed's prior statements on SQLite not needing a > "begin". But when the "self._cursor.commitTransaction()" fires - I get an > error. The error is there is no transaction started (as I reported in the > earlier email). >
Am I completely out to lunch with this????? Please respond ;-) -- 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]
