sqlite query not working

[John Salerno]

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 behavior.  I can see both sides of the
> fence...it's just a hassle to sniff out which DB drivers
> autocommit and which don't.

What's really strange is that I'm pretty sure (but can always be wrong) 
that I've written SQLite queries just as above, and they were saved to 
the DB without a commit() call, so it's not like I was even using a 
different system. Ah well, I'm sure there was *something* different 
about the two cases! :)