MySQL/MariaDB Select RowSet with empty Table


I tested some things with the “new” way to work with Databases. The docs do that with “for… each”.
When doing that with MySQL this way doesn’t work.
If you select data from an empty table, you need to check “If not rows.AfterLastRow” before you do the " For Each row As DatabaseRow In rows". I think that should be mentions in the docs or is it there and I can’t see it?



this is a known bug in all or most of the database plugins. I filed a bug report for it. I don‘t know the feedback case ID of it but you can search in feedback.
The for … each iterator does one iteration even if the rowset has no rows.

Best regards