Re: [sqlite] opening sqlite in write mode in Python

> Does anyone know how to open a connection to sqlite database from Python in write > mode? Did you remember to commit your writes? import sqlite cx = sqlite.connect('test.db') cu = cx.cursor() cu.execute('create table t1 (a,b,c)') cu.execute('insert into t1 values (1,2,3)') cx.commit() cu.

[sqlite] opening sqlite in write mode in Python

Hello, I am writing Python code to access a database. While I am successful in running SELECT queries, I can not run INSERT queries. I suspect that the mode that sqlite is being connected to is read only. Does anyone know how to open a connection to sqlite database from Python in write mode