On Wednesday, October 08, 2014 11:04:33 PM Simon Slavin wrote:
> On 8 Oct 2014, at 10:45pm, Mark Halegua <[email protected]> wrote:
> > I think my problem is I've opened the database in different modules for
> > different views of the data (there are six tables, one of which relates
> > to two/three others, another which relates to one other) and therefore
> > the database is locked for anything like adding data.
> If you are using Shared Cache Mode, then you are using shared access to the
> database. So whatever _open() command you use first is governing the
> access all modules have.
>
> It may be that whatever Python library you're using automatically uses
> shared cache mode without you intentionally turn it on.
>
> Are you using any special directives or PRAGMAs ?
>
> Simon.
Simon,
No. Just plain
db - sqlite.connect()
cdata = db.cursor()
This is in the contect of Python/pysqlite2 which I import as follows
from pysqlite3 import dbapi2 as sqlite
Mark
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
