On 4 Apr 2019, at 17:30, Lifepillar <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
