Status 100 shows up after a sqlite3_step() as a kind of “OK, not EOF”.
https://www.sqlite.org/c3ref/step.html
Also read about Compiling An SQL Statement and Reset A Prepared Statement Object
And have in mind that the sqlite3_prepare() interface is legacy and should be avoided.
0, 100 and 101 are Ok steps. I think that in some point under some condition, Xojo DB engine have some bug that mistakenly leaks some step status as an error to an upper layer.