You don't list your trigger definition if there's anything that might need troubleshooting, but I will say that I've recently stopped using SQLiteStudio for its somewhat erratic behavior.
While it's got a great regex implementation (which doesn't port to running in pure CLI-based scripts) and a no-nonsense GUI, it also tends to flake out with memory issues on relatively small databases. I also cannot find if it's actively supported; no recent versions or activity on the forum. You might need to crosscheck your results within alternates like SQLiteAdmin or dbVis. Regards. Brian P Curley On Sun, Aug 26, 2018, 3:41 AM Csányi Pál <csanyi...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
