Re: [sqlite] CASE WHEN sample ?

Am 11.05.2008 um 22:25 schrieb Igor Tandetnik: > "Lothar Behrens" > <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> Unique index and using replace into ... changes the primary key value, >> what I cannot handle yet, because I am using triggers >> to force foreign key referential

Re: [sqlite] CASE WHEN sample ?

"Lothar Behrens" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Unique index and using replace into ... changes the primary key value, > what I cannot handle yet, because I am using triggers > to force foreign key referential integrity and updating is not yet > implemented. Use

Re: [sqlite] CASE WHEN sample ?

--Original Message- > From: Lothar Behrens <[EMAIL PROTECTED]> > Sent: Saturday, May 10, 2008 2:23 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] CASE WHEN sample ? > > Hi, > > I am searching for a sample that uses the case when expression. > I like to

Re: [sqlite] CASE WHEN sample ?

te.org Subject: [sqlite] CASE WHEN sample ? Hi, I am searching for a sample that uses the case when expression. I like to insert values into a table when these values are not in that table before. My tries to read, understand and try the documentation of expressions failed. Executing this statemen

Re: [sqlite] CASE WHEN sample ?

"Lothar Behrens" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Executing this statemen twice creates two rows: > > replace into anwendungen (name) values ('lbDMF Manager') Make "name" column unique, or create a unique index on it. Igor Tandetnik

[sqlite] CASE WHEN sample ?

Hi, I am searching for a sample that uses the case when expression. I like to insert values into a table when these values are not in that table before. My tries to read, understand and try the documentation of expressions failed. Executing this statemen twice creates two rows: replace into