Re: [sqlite] How can SQLite return indication of where SQL failed?

2005-01-16 Thread Peter Bartholdsson
On Sun, 16 Jan 2005 02:42:52 -0800, <[EMAIL PROTECTED]> wrote: I'm using Delphi 4 and various versions of SQLite wrapper. To begin, my only desire is to write SQL in a text box and execute it. What I'd like if a pointer to the place in the SQL where the syntax fails, and I'm presuming the in-DLL

Re: [sqlite] Is there any way to enable recursive triggers?

2005-01-04 Thread Peter Bartholdsson
On Tue, 04 Jan 2005 05:54:04 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: Peter Bartholdsson wrote: Think the topic explains it but there any way to enable recursive triggers? Aka, triggers that run as result of a change by a trigger. Recursive triggers are on the tod

[sqlite] Is there any way to enable recursive triggers?

2005-01-04 Thread Peter Bartholdsson
Think the topic explains it but there any way to enable recursive triggers? Aka, triggers that run as result of a change by a trigger. Regards, Peter Bartholdsson

Re: [sqlite] Recursive Triggers

2004-12-31 Thread Peter Bartholdsson
ective code or anything, right now I have to add a custom function that gets called in my update triggers which then do an update upward (in a tree) on records which feels like a bad solution to the problem. Regards, Peter Bartholdsson

Re: [sqlite] index not used?

2004-12-12 Thread Peter Bartholdsson
On Sun, 12 Dec 2004 15:41:48 +0100, Christian Schwarz <[EMAIL PROTECTED]> wrote: Normally, a select-statement would look like this (where 1 is the current day): select * from relations where valid_from < 1 and valid_to > 1 and rel_id_from = 78 and rel_id_to = 9120; This kind of

[sqlite] Update multiple columns from subquery

2004-11-11 Thread Peter Bartholdsson
Is there some way to write this query in SQLite? UPDATE groups SET (fileCount, size) = (SELECT count(id), sum(size) FROM files where groupId = 15) WHERE groupId = 15; Or must it be written like this? UPDATE groups SET fileCount = (SELECT count(id) FROM files where

Re: [sqlite] Release / development timeline

2004-11-03 Thread Peter Bartholdsson
On Mon, 1 Nov 2004 19:23:58 -0800, Jonathon Blake <[EMAIL PROTECTED]> wrote: How about a simple page that gives projected release date for upgrades? Something like Version 3.0.9 beta 10 November Version 3.0.9 final 20 November Version 3.0.10 beta 1 December Version 3.0.10 final

Re: [sqlite] Problems compiling SQLite 3.0.7 with MinGW

2004-09-21 Thread Peter Bartholdsson
\3.4.1\..\..\..\..\mingw32\bin\ld.exe: cannot find -lpthread collect2: ld returned 1 exit status c:\msys\mingw\bin\mingw32-make.exe: *** [sqlite3.exe] Error 1 Oh thank you, this makes me feel a lot better. ^^ Regards, Peter Bartholdsson

Re: [sqlite] Problems compiling SQLite 3.0.7 with MinGW

2004-09-21 Thread Peter Bartholdsson
On Tue, 21 Sep 2004 13:15:52 +0200, Martins Mozeiko <[EMAIL PROTECTED]> wrote: Did you try googling for "pthreads win32": http://sources.redhat.com/pthreads-win32/ If you want thread safety with sqlite then you must install this pthreads library, if not - then just rerun ./configure with

[sqlite] Problems compiling SQLite 3.0.7 with MinGW

2004-09-21 Thread Peter Bartholdsson
was linux related, none of it related to MinGW. Apparently it's something called liblpthread, however I've not seen this for MinGW and none of the packages I've installed seems to include it. Anyone have any ideas? Regards, Peter Bartholdsson