RE: [sqlite] a newbie

> From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 3 Jan 2008 15:21:47 -0600 > Subject: [sqlite] a newbie > > Hey guys, > > My name is Scott Berry and I am totally blind and a newbie to Sqlite. I > have two questions concerning Sqlite. The questions I have is I have an > Exce

RE: [sqlite] Functions embedded in SQL statements

of the two functions I mentioned (ifnull, strftime) on those pages. bb --- Christopher Smith <[EMAIL PROTECTED]> wrote: > The C/C++ documentation can be found here: > http://sqlite.org/capi3ref.html#sqlite3_create_function > > For those of us in the mortal category, various

RE: [sqlite] Functions embedded in SQL statements

The C/C++ documentation can be found here: http://sqlite.org/capi3ref.html#sqlite3_create_function For those of us in the mortal category, various wrappers can make life better. For example, http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-user-defined-functions HTH, Chris

[sqlite] RE: ezmlm response

SQLite illuminati, Some questions: 1. If the integer primary key (say, tbl_pers.pers_id) is the b-tree value for the row, is it necessary to compose update triggers to handle a DELETE FROM tbl_pers WHERE pers_id=5; for all of the tables holding pers_id as a foreign key? 2. I want to update t