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

> any plans/desires to fix this I hesitate to announce this for reasons I'll explain below, but I have been working on an experimental version on the SQLite pager called the Shadow Pager. The Shadow Pager is intended to address this problem for applications that use SQLite from a single process on

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

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > The important thing to understand here, is that you're not stepping > through a set of results that you have in memory and that > were extracted > from the database. You are (at least for simple queries) > ste

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

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 co

[sqlite] locked - what am I doing wrong?

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 another

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

- 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

[sqlite] locked - what am I doing wrong?

Hello everyone, I have built sqlite myself (using VC 6.0), I am using the sqlite_step interface for iterating a tables rows. I am having a bit of a hard time understanding something: When I am in the middle of stepping (sqlite_step) through the results of a table query, the database is locked.