Hi, I have a small database with schema attached in this mail. I have two triggers to update fields after an update occures.
When I run the SQL code in sqlite3 CLI, or in SqliteStudio's SQL Editor, it output is that I expect. It gives the numbers of months and days so far: SELECT total(RemainingDays) FROM MyLengthOfService; total(RemainingDays) 63 SELECT total(RemainingDays) % 30 FROM MyLengthOfService; total(RemainingDays) % 30 3 But even if I run the trigger in SqliteStudio's SQL Editor alone, it does not give the expected output: UPDATE SummedYearsMonthsDays SET RemainingSummedDays = CASE WHEN ( SELECT total(RemainingDays) FROM MyLengthOfService ) < 30 THEN RemainingSummedDays = ( SELECT total(RemainingDays) FROM MyLengthOfService ) ELSE RemainingSummedDays = ( SELECT total(RemainingDays) % 30 FROM MyLengthOfService ) END WHERE id = 1; The output is empty. When the trigger is fired, those numbers are not updated in the corresponding fields of the corresponding table. To be more precise, the AllYearsMonthsDays trigger does not work. The YearsRemainingMonthsDays trigger works. What am I missing here? -- Best, Pali Üdvözlettel, Csányi Pál tanár _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
