[sqlite] Problem with page cache

2020-01-17 Thread sqlite3
The pcache1FetchStage2 function has "*(void **)pPage->page.pExtra = 0;" although this does not seem to be documented, nor is there an assertion in pcache1.c (although in pcache.c there is). Perhaps the documentation should be corrected. ___ sqlite-users

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

2019-10-13 Thread sqlite3
Brannon King wrote: > [...] I'd like to propose that we upgrade to something more modern and > secure like Sympa or mlmmj, or even a more drastic system upgrade to > something like Redmine -- a project tracker + forum. I would propose instead to upgrade to a NNTP. (I even wrote a NNTP software t

[sqlite] Who has the sqlite3.dll and lib for version 3_3_14 for windows

2007-11-23 Thread learning Sqlite3
Hello, Who have the sqlite3.dll and sqlite3.lib of version 3_3_14 for windows. I created them wtih visual studio 2005. But they did not work. Or tell me how I can create them with visual studio 2005 porperly? Thanks! _ Invite

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

2007-11-19 Thread learning Sqlite3
Thanks! I just make sure if it was caused by sqlite3. It it is not, I will ask apr. > Date: Mon, 19 Nov 2007 12:20:35 +0100 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] cannot commit - no transaction is active > > On Nov 19, 2007 9:15 AM

[sqlite] cannot commit - no transaction is active

2007-11-19 Thread learning Sqlite3
Hello, 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_end(driver, pool, transaction); It always gives the error message: can

[sqlite] PRAGMA synchronous = NORMAL and Error = 21

2007-11-18 Thread learning Sqlite3
Hello, I use the function: apr_dbd_query(driver, sqlite3, &nrows, "PRAGMA synchronous = NORMAL"); But I always get the error and error code is 21. In addtion, rows=(null). Does it mean I should insert some rows into SQlite3 before I use apr_dbd_qu