Beware of Xojo 2021 R2.x if you use SQLite

[AlbertoD]

SQLite: Another row available

I’m getting reports of an exception that makes no sense to me. I’m getting a DatabaseException with the message another row available on the line Var Rows As RowSet = SelectSQL("SELECT * FROM maps ORDER BY official DESC, sort;"). This is one of the least helpful errors I’ve ever seen. I also haven’t been able to reproduce it myself, this is coming from my automated reporter. It’s also pretty new, though my IDE version has not changed. This is likely to be something to do with the database and n…