Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

I think you need 3.3.8 or greater. On Mon, 2007-03-26 at 07:39 +0200, stephan nies wrote: > I am using sqlite 3.3.5 . > > On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote: > > > > What version of SQLite are you using? I'm not sure the IF EXISTS option > > was present until a certain version

Re: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

I am using sqlite 3.3.5 . On 3/25/07, Eric Pankoke <[EMAIL PROTECTED]> wrote: What version of SQLite are you using? I'm not sure the IF EXISTS option was present until a certain version of 3.x (though I'm not sure which version). Eric Pankoke Founder Point Of Light Software

[sqlite] SQLite installation problems

Hi, I'm trying to install SQLite in order to use Trac with our SVN repositories. We're running RedHat 4 Ent. I downloaded the source code file sqlite-3.3.13.tgz and followed the README on how to compile but ran into the problem that the header file "tcl.h" could not be found, even though I

Re: [sqlite] Store and retreive 0D0A (CRLF) in string field

SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by whatever wrapper you use on top of SQLite, or simply an artifact of the way you inspect the data (e.g. you look at the string in a debugger, and the debugger just happens to show

Re: [sqlite] using SQLite with flash file systems

On 3/25/07, John Fisher <[EMAIL PROTECTED]> wrote: I note from the home page that "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures". Is this still the case if the database is stored on a flash file system, say JFFS2 with the linux

[sqlite] using SQLite with flash file systems

I note from the home page that "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures". Is this still the case if the database is stored on a flash file system, say JFFS2 with the linux kernel?

RE: [sqlite] Questions on views

Thank you for the reply. Is doing a SELECT EXISTS (...) faster than a SELECT COUNT (... LIMIT 1) or would it be the same (I would expect them to be the same, but that's only my guess)? Regards, Dennis > -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent:

Re: [sqlite] UTF-8 or ISO-8859-1

At 9:42 PM +0200 3/25/07, Ralph Müller wrote: to store (german) Text in a SQLite Database, is it better to use UTF-8 or is ISO-8859-1 more recommendable? It is recommended to use UTF-8 no matter what language text is in the database, since it is fully adaptable to any situation. Also, with

Re: [sqlite] UTF-8 or ISO-8859-1

Ralph Müller schrieb: Hi all, to store (german) Text in a SQLite Database, is it better to use UTF-8 or is ISO-8859-1 more recommendable? UTF-8. Frank - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] UTF-8 or ISO-8859-1

Hi all, to store (german) Text in a SQLite Database, is it better to use UTF-8 or is ISO-8859-1 more recommendable? Thx in advance 4 help. Cheers! Ralph PS: Please excuse my terrible english. Thx. - To unsubscribe,

RE: [sqlite] CREATE TRIGGER IF NOT EXISTS throws error

What version of SQLite are you using? I'm not sure the IF EXISTS option was present until a certain version of 3.x (though I'm not sure which version). Eric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message- From: stephan nies [mailto:[EMAIL

[sqlite] CREATE TRIGGER IF NOT EXISTS throws error

Hello, when i build a test table with: CREATE TABLE test(a text); and try to implement a trigger using: CREATE TRIGGER IF NOT EXISTS trig_name BEFORE INSERT ON test FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'blabla') WHERE NEW.a = 'pong'; END; I get this error message: SQL error: near "NOT":

Re: [sqlite] sqlite segfault using libc library

Rich Rattanni wrote: On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: Andrew Finkenstadt wrote: > On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> Compilers do not terminate strings, library functions do. > > > > You are guaranteed by the C standard that the string referred to by

[sqlite] Re: Store and retreive 0D0A (CRLF) in string field

fangles <[EMAIL PROTECTED]> wrote: When I have text pasted into an sqlite string field, it is stored okay but when I retrieve a string, it is truncated at the first CR (0D). SQLite doesn't truncate anything. Whatever you put in you get out. If you see a truncation, it is either done by

[sqlite] Any way to do this faster?

Simplified I have the following situation: 2 tables, tableA and tableB both with an integer field, called ID, holding unique integer numbers in tableA and non-unique integer numbers in tableB. Both tables have an index on this field and for tableA this is an INTEGER PRIMARY KEY. Now I need to

SV: [sqlite] sqlite and bcc32

I use SQLite 3.1.15 Build 1.0.1911.21749 -Ursprungligt meddelande- Från: stripe [mailto:[EMAIL PROTECTED] Skickat: den 25 mars 2007 10:22 Till: sqlite-users@sqlite.org Ämne: Re: [sqlite] sqlite and bcc32 using sqlite version 3.3.13. .. extern "C" { #include } ... doesn't help :(

Re: [sqlite] sqlite and bcc32

using sqlite version 3.3.13. ... extern "C" { #include } ... doesn't help :( -- View this message in context: http://www.nabble.com/sqlite-and-bcc32-tf3458305.html#a9658088 Sent from the SQLite mailing list archive at Nabble.com.

SV: [sqlite] sqlite segfault using libc library

Yes it's same massage in this 3 PC's -Ursprungligt meddelande- Från: Rich Rattanni [mailto:[EMAIL PROTECTED] Skickat: den 24 mars 2007 22:23 Till: sqlite-users@sqlite.org Ämne: Re: [sqlite] sqlite segfault using libc library On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: > Andrew