Re: [sqlite] fetching and updating

2008-04-21 Thread Igor Tandetnik
Mike Johnston <[EMAIL PROTECTED]> wrote: > OK, so that makes sense. What I see happening is creation of a > journal file when i do the update/insert/delete statement each of > which return SQLITE_OK. However, nothing is visible from an outside > process (like sqlite3). If I understand you, th

Re: [sqlite] fetching and updating

2008-04-21 Thread Mike Johnston
OK, so that makes sense. What I see happening is creation of a journal file when i do the update/insert/delete statement each of which return SQLITE_OK. However, nothing is visible from an outside process (like sqlite3). If I understand you, this journal will be applied once the sqlite3_st

Re: [sqlite] fetching and updating

2008-04-21 Thread Igor Tandetnik
"Mike Johnston" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm running the 3.5.7 version now. My understanding was that if I > have a prepared statement and currently using sqlite_step to walk > through the results, the database was unable to commit a write. You cannot commit a

Re: [sqlite] fetching and updating

2008-04-21 Thread Mike Johnston
I'm running the 3.5.7 version now. My understanding was that if I have a prepared statement and currently using sqlite_step to walk through the results, the database was unable to commit a write. In my case, I would be using the same connection. Would you explain more? Also, what if same conn

Re: [sqlite] fetching and updating

2008-04-19 Thread Igor Tandetnik
"Mike Johnston" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm in a loop processing the result set using sqlite3_step. I need to > insert/update the same sqlite database but a different table. I > can't get the write lock while I have this active statement I'm using > sqlite3_st

[sqlite] fetching and updating in Ruby

2008-04-18 Thread Mike Johnston
Hi, Does anyone on the list use the sqlite3 gem with Ruby? Is this list ok to post sqlite/ruby questions? Many thanks in advance Mike - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. __

[sqlite] fetching and updating

2008-04-18 Thread Mike Johnston
Hi, I'm in a loop processing the result set using sqlite3_step. I need to insert/update the same sqlite database but a different table. I can't get the write lock while I have this active statement I'm using sqlite3_step to move through. I'm sure this is pretty common so what's the conventio