RE: [sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115

When you're saying "free," do you mean "free, as in a beer?" Or are you talking about closed source free software? I came in late. -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 5:19 PM To: Griggs, Donald; [EMAIL PROTECTED] Subject: RE: [sqlite

RE: [sqlite] Re: SQLite version 3 design question: '500'=500?

I think it should return 0. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] Autoincrement of primary key

SQLITE FAQ: (1) How do I create an AUTOINCREMENT field. Short answer: A column declared INTEGER PRIMARY KEY will autoincrement. Here is the long answer: Beginning with version SQLite 2.3.4, If you declare a column of a table to be INTEGER PRIMARY KEY, then whenever you insert a NULL into that

RE: [sqlite] CREATE TABLE on conflict ignore?

As far as I can tell there is no conflict cause on the CREATE TABLE statement, however all the table information is stored in a table called "sqlite_master." SELECT count(*) FROM sqlite_master WHERE name = "my_table_name"; That should return "1"; So, if you're a SQL guru you might be able to wo

RE: [sqlite] Change value on a trigger

There is an entire section in the SQL language specification dedicated to triggers, if you need further help just come and ask. http://www.sqlite.org/lang.html Regards, PeterP. -Original Message- From: António Vieira (DSI) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 11:29

RE: [sqlite] Difference between Transaction Journal and Checkpoint Journal

I'm going to make an assumption here, but it might make sense that the three are related to each other. Ie: A "journal" entry points to a entry in the "transaction journal," and "checkpoint journal." -- Journal: A mechanism which tracks changes made to data in the database between checkpoints.

RE: [sqlite] mySQL to SQLite conversion question

1) adrsId INTEGER PRIMARY KEY If you insert a null value in "adrId," or not insert anything at all, then it will auto incremement. 2) You will not require NOT NULL, think about it. 3) I've found a really good e-book on advanced databasing, you can pick up a free copy here: http://216.197.101.104

RE: [sqlite] Compute clauses

Yup. SELECT SUM(client_id) FORM client; That will return the sum of client_id; Regards, PeterP - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] sqlite newbie tutorial

I've written a newbie tutorial for C# developers, because I am a newbie and it's a rule to write about what you know so, check it out: http://www.podbox.co.za/sqlite.html and give me some feedback. - To unsubscribe, e-mail:

[sqlite] Ignore my last problem

Excuse me everyone, I've solved it. Besides the obvious syntax error, which was a copy/paste error, I was busy working on my release database, whilst running my debug application, hence All the changes I was making didn't reflect. ---

[sqlite] UNIQUE ON CONFLICT IGNORE problem?

CREATE TABLE mailLst ( mailId INTEGER PRIMARY KEY, mailMID INTEGER UNIQUE ON CONFLICT IGNORE mailDateBegin DATETIME, mailDateEnd DATETIME, mailDateTime DATETIME, mailTo VARCHAR, mailFrom VARCHAR, mailSize VARCHAR, mailSpam VARCHAR, mailStatus VARCHAR ); I've created this table a