On 4 Apr 2019, at 17:30, Lifepillar <lifepil...@icloud.com> wrote: > >> You have the option to ignore the error, though, in which case you get +Inf: > > sqlite> delete from decTraps where flag = 'Division by zero'; > sqlite> select decStr(decDiv(1,0)); > Infinity
Forgot to mention that in this case a flag is silently added to another virtual table called decStatus: sqlite> select * from decStatus; Division by zero so you may still query for errors. You have to manually clear the status then: delete from decStatus; -- Clear the status flags Life. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
