Dennis Lee Bieber wrote:
> The other thing to consider is that, if you were testing using a
> single cursor, and single session, the database would have shown you
> uncommitted changes. It wouldn't have been until you closed the
> cursor/connection without a commit that the DBMS would have t
BartlebyScrivener wrote:
> John Salerno wrote:
>
>>> Ah well, I'm sure there was *something* different
>
> Are you sure that it's not you were doing SELECT before, as opposed to
> INSERT?
Perhaps. It might have been that I used the INSERT statement on the
sqlite command line, then used SELECT i
John Salerno wrote:
>> Ah well, I'm sure there was *something* different
Are you sure that it's not you were doing SELECT before, as opposed to
INSERT?
rd
--
http://mail.python.org/mailman/listinfo/python-list
Tim Chase wrote:
> I tinkered with the mx.ODBC drivers a bit and had a similar
> difficulty until I realized that it was configured to *not*
> autocommit. At least in the mx.ODBC drivers, you can pass a
> param ("clear_auto_commit=1") to the Connect() call to restore
> "normal" autocommiting beha
>> Have you tried adding a self.connection.commit() to the
>> code? I don't know whether sqlite is transactional, but if
>> it is then the changes will disappear without a commit.
>
> Wow, that worked! Now, I know I've done some DB work before
> (very similar to this) and never used commit(), so I
Steve Holden wrote:
> Have you tried adding a self.connection.commit() to the code? I don't
> know whether sqlite is transactional, but if it is then the changes will
> disappear without a commit.
Wow, that worked! Now, I know I've done some DB work before (very
similar to this) and never used
John Salerno wrote:
> Hopefully this is enough code to reveal the problem. When I run the
> program, there are no error messages produced, it's just that the values
> I enter don't seem to get put into the database, even though the query
> seems to be ok.
>
>
> def OnSaveRecord(self, even
Hopefully this is enough code to reveal the problem. When I run the
program, there are no error messages produced, it's just that the values
I enter don't seem to get put into the database, even though the query
seems to be ok.
def OnSaveRecord(self, event):
textfield_values = []
