Re: [sqlite] locked - what am I doing wrong?

2004-01-08 Thread D. Richard Hipp
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

[sqlite] locked - what am I doing wrong?

2004-01-08 Thread Kennedy, Dan
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

Re: [sqlite] locked - what am I doing wrong?

2004-01-08 Thread ben . carlyle
- 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]>