Re: [sqlite] update statements inside select...case inside triggers

> CREATE TRIGGER trigger_name AFTER UPDATE ON table > BEGIN > SELECT CASE > WHEN a_condition THEN > UPDATE another_table SET a_field=a_value WHERE yet_another_condition > WHEN another_conditon THEN > UPDATE another_table SET a_field=another_value WHERE > yet_another_conditi

[sqlite] update statements inside select...case inside triggers

Hi All, I'm trying to do the following: CREATE TRIGGER trigger_name AFTER UPDATE ON table BEGIN SELECT CASE WHEN a_condition THEN UPDATE another_table SET a_field=a_value WHERE yet_another_condition WHEN another_conditon THEN UPDATE another_table SET a_field=another_value WH