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 >>>> http://sqlite.com/lang_createtrigger.html >>> >>> Which part do you feel is in violation of the diagram? >> >> I cant find anything about >> SELECT CASE >> ... >> END; >> >> in the diagram and i dont understand, how it works. > Have a look at: > http://sqlite.org/lang_expr.html > > Michael >
OK. I found it. I thougt, CASE ... END belonged to TRIGGER, but it belongs to SQL. I just found http://www.sqlite.org/lang_expr.html#case Thank you for pointing me in that direction. Wolfgang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users