David Swigger wrote:
I open two connections:
pConn1 = sqlite_open(m_sDbPath.c_str(),0,NULL);
pConn2 = sqlite_open(m_sDbPath.c_str(),0,NULL);
I do the query and compile a query on conn1, then
start stepping through the rows of results.
If I try to do any execs using pConn2 - I always get
an error
When you first call sqlite_step() for your SELECT statement, SQLite
grabs a read-lock on the database file. It doesn't release this lock
until you call sqlite_finalize(). When you execute your UPDATE, SQLite
needs to get a write-lock on the database file. It can't get the
write-lock while
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 09/01/2004 10:44 AM -
Ben Carlyle
09/01/2004 09:35 AM
To: "David Swigger" <[EMAIL PROTECTED]>@CORP
cc:
Subject:Re: [sqlite] locked - what am I doing wrong?
G'day,
"David Swigger" <[EMAIL PROTECTED]>
3 matches
Mail list logo