I posted about this awhile back in an older topic, but this has become worse with 2021r1:
The RowData function for a WebListBox 2.0 errors out when loading data from a MySQL DB with, “A Query is already in progress”. In my tracking this down, I can make the WebListBox example app do the same thing by changing the source database from the SQLite version to a MySQL version. You can see the same thing by importing the Eddies Electronics DB into a MySQL DB and changing the connection to it.
My theory is that the SQLite db doesn’t run into it because it’s a local file, in memory and not subject to network latency and the overhead of remote query. It’s not my database server… it has 20 physical cores, 384GB RAM, 10GB NIC and has no problem running huge queries extremely fast.
This issue along with the WebListBox.SelectedRowIndex always returning -1 when using filtering (FB 63801) makes the new WebListBox pretty unusable for me.
Before I file a bug report, has anyone found a workaround for using MySQL as a WebListBox datasource while avoiding this? Not being able to use the new WebListBox and it’s datasource features is extremely frustrating and I need to get this done.
Thanks in advance!