The following statement:
@db.execute("INSERT INTO log_files VALUES (NULL, ?)", @filename)
is not resulting in a persistent insert into the database (although it
is apparently resulting in a temporary insert). The problem is not a
transactional one, because if I issue a “commit” statement afterwards,
I get an error message stating that no transaction is active. Anyone
have any ideas what might be happening here? The corresponding code
from Python works just fine.