Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Wolfgang Meiners
Am 04.06.12 19:36, schrieb Igor Tandetnik: > > http://sqlite.org/lang.html > http://sqlite.org/syntaxdiagrams.html > I just found the case expression. I did not know it before. Thank you for pointing me to that direction! Wolfgang ___ sqlite-users mail

Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Wolfgang Meiners
Am 04.06.12 19:31, schrieb Michael Schlenker: > Am 04.06.2012 19:25, schrieb Wolfgang Meiners: >> Am 04.06.12 18:59, schrieb Igor Tandetnik: >>> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on >

Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Igor Tandetnik
On 6/4/2012 1:25 PM, Wolfgang Meiners wrote: Am 04.06.12 18:59, schrieb Igor Tandetnik: On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on http://sqlite.com/lang_createtrigger.html Which part do you fe

Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Michael Schlenker
Am 04.06.2012 19:25, schrieb Wolfgang Meiners: > Am 04.06.12 18:59, schrieb Igor Tandetnik: >> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: >>> this trigger does work but i think it is not in accordance with the >>> syntax diagram of TRIGGER on >>> http://sqlite.com/lang_createtrigger.html >> >> W

Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Wolfgang Meiners
Am 04.06.12 18:59, schrieb Igor Tandetnik: > On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: >> this trigger does work but i think it is not in accordance with the >> syntax diagram of TRIGGER on >> http://sqlite.com/lang_createtrigger.html > > Which part do you feel is in violation of the diagram?

Re: [sqlite] Trigger, syntax question

2012-06-04 Thread Igor Tandetnik
On 6/4/2012 12:33 PM, Wolfgang Meiners wrote: this trigger does work but i think it is not in accordance with the syntax diagram of TRIGGER on http://sqlite.com/lang_createtrigger.html Which part do you feel is in violation of the diagram? -- Igor Tandetnik

[sqlite] Trigger, syntax question

2012-06-04 Thread Wolfgang Meiners
Hi, I have written the following trigger with ideas from stackoverflow: (OSX 10.6.8, SQLite 3.6.12) This is for a book library. If i delete a bookexemplar from the library, this should not be possible if this bookexemplar is on loan, which means ausleihen.rueckgabe IS NULL. Otherwise every infor