Re: [sqlite] cannot commit - no transaction is active

On Nov 19, 2007 9:15 AM, learning Sqlite3 <[EMAIL PROTECTED]> wrote: > I use the function: > apr_dbd_transaction_start(driver, pool, sql, >&transaction); > to start a transaction. > > But when I close this transaction with the function: > apr_dbd_transaction

Re: [sqlite] Unicode

On 7/30/07, wcmadness <[EMAIL PROTECTED]> wrote: > I'm stuck on this. I'm writing a data layer that potentially needs to handle > diacritical (sp?) characters, such a French accented é characters or German > umlauted characters (sp?). It should be rare that I would run into > something like this

Re: [sqlite] Milliseconds

On 7/12/07, Steinmaurer Thomas <[EMAIL PROTECTED]> wrote: Hello, is there a way to retrieve and store the millisecond part of a (current) timestamp? If you're on a Unix-like system, have a look at gettimeofday which returns: struct timeval { longtv_sec; /* seconds since Jan. 1,

[sqlite] Re: sqlite3_step returns different error codes depending on PRAGMA cache_size

While the bulk INSERTs are being performed, I have a small shell script that runs sqlite3 database.db "select count(*) from table" in loop and sleeps 1 seconds between iterations. Occasionally, sqlite3_step returns an error probably due to concurrency issues. This is fine. However, that puzzles

[sqlite] sqlite3_step returns different error codes depending on PRAGMA cache_size

I have an application that does bulk INSERTS into a table. Simplified pseudo code is below: sqlite3_open(dbh); sqlite3_prepare(stmt); for (i=0; i < 10; i++) { sqlite3_bind(i); sqlite3_step(stmt); sqlite3_reset(stmt); } sqlite3_close(dbh); While the bulk INSERTs are being performed