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
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
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
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
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
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
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
\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
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
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
10 matches
Mail list logo