Re: [sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread Markus Kolb
jpadie wrote: > 2. the linux servers are debian 2.4.28 (so they say). i read that 2.4 was > not a stable release so i am assuming they mean 2.2.x in any event With Debian 2.4.28 I think of a Debian release with kernel version 2.4.28. This means it is a Debian distribution with a self-compiled

Re: [sqlite] Questions to autocommit mode

2006-03-25 Thread Markus Kolb
[EMAIL PROTECTED] wrote: > Markus Kolb <[EMAIL PROTECTED]> wrote: >> Hello, >> >> I have some questions to autocommit mode of SQLite 3.3.4 and its >> transactions. >> >> Did I understand it right that new or changed row data is only written >

[sqlite] Questions to autocommit mode

2006-03-25 Thread Markus Kolb
Hello, I have some questions to autocommit mode of SQLite 3.3.4 and its transactions. Did I understand it right that new or changed row data is only written to disk when the db connection is closed with sqlite3_close? Did I understand it right that after a transaction commit, autocommit is enabl

Re: [sqlite] cannot commit transaction - SQL statements in progress

2006-03-07 Thread Markus Kolb
Markus Kolb wrote: > Hello, > > I open one connection to a sqlitedb and do a few successful autocommited > sqlite3_exec() calls. > Then I want to use the db handle to call another sqlite3_exec() with SQL > code for a transaction. > Before I close the connection I call agai

[sqlite] cannot commit transaction - SQL statements in progress

2006-03-06 Thread Markus Kolb
Hello, I open one connection to a sqlitedb and do a few successful autocommited sqlite3_exec() calls. Then I want to use the db handle to call another sqlite3_exec() with SQL code for a transaction. Before I close the connection I call again sqlite3_exec() with SQL COMMIT to end the transaction.