From: Clifford Heath <no@...>
Date: 2007-10-17T09:00:07+09:00
Subject: Re: SQLite3::SQLException: SQL logic error or missing database

Une B�vue wrote:
> But the INSERT itself triggers (see "CREATE TRIGGER INSERT_PBK_TRIGGER
> AFTER INSERT ON devicephonebook" above) an UPDATE which might violate
> SQLite's non-reentrant requirement ???
> Am I right here ?

I'm not an sqlite3 guru by any means, but I'd be amazed if that was it.
It's not that sqlite is non-reentrant, but that it only supports one
transaction at one time (subtle difference). The UPDATE is (or should
be!) part of the same transaction.

I suggest you find the SQlite developer community and ask there.

Clifford Heath.