[sqlite] How to change journal location?

Hi all! Is there a way to change the location of the journal file? We would like to have journal in some other directory than the database. Regards Simon -- Simon Posnjak Četrta pot, d.o.o. Planina 3 4000 Kranj Slovenija, EU

Re: [sqlite] UPDATE reports SQL logic error or missing database

hich is goto abort_due_to_error (:4975) -vdbe.c:4980 -> goto vbe_halt (:4947) -vdbe.c:4948 -> rc > 0 == true -vdbe.c:4950 -> rc = SQLITE_ERROR <== PROBLEM we forget the correct error code -vdbe.c:4956 -> return rc (value is 1) == WRONG! I added it as a bug (ticket 1965). Regards Simon

[sqlite] UPDATE reports SQL logic error or missing database

Hi all! When I try to do UPDATE of a record i get: SQL logic error or missing database (error code 1)? The database is not missing or corrupted because I can UPDATE stuff in it with sqlite3 and I can INSERT into, SELECT from it and also DELETE. My application uses two threads. The first thread

Re: [sqlite] CE locking -- review the code

Robert Simpson wrote: - Original Message - From: "Simon Posnjak" <[EMAIL PROTECTED]> Robert Simpson wrote: I incorporated the locks into the latest CVS version of os_win.c and it's available here: http://sqlite.phxsoftware.com/os_win.c Would i be possible to post

Re: [sqlite] CE locking -- review the code

Robert Simpson wrote: - Original Message - From: "Doug Nebeker" <[EMAIL PROTECTED]> Two comments: * This should only be used for Windows CE as-is. On Windows XP/2000/2003(?)/Terminal Services you should probably add "Global\" to the front of the mutex name so the lock is truly

Re: [sqlite] [PATCH] WinCE compilation

[EMAIL PROTECTED] wrote: Simon Posnjak <[EMAIL PROTECTED]> wrote: Would it be possible if [Steve Lhomme's] port [to WinCE] and the sf port could be merged together in main line src tree? I have attempt to do this, but I have no way to test it. Anybody who is able to do

Re: [sqlite] [PATCH] WinCE compilation

Hi, I do not now if you found it but there is another port of sqlite to WinCE. You can find it at http://sqlite-wince.sourceforge.net/. Would it be possible if your port and the sf port could be merged together in main line src tree? Regards Simon On sre, 2006-01-04 at 10:13 -1000, Steve

[sqlite] uclibc and sqlite

Hi all, As someone already reported uclibc and sqlite do not play nice together. I did a bt after a segfault and got: #0 0x00089f8c in sqlite3OsFileSize (id=0xf0434, pSize=0x0) at src/os_unix.c:816 #1 0x000bea10 in sqlite3pager_pagecount (pPager=0xf0428) at src/pager.c:1750 #2 0x000c0062