Xojo2024R3.1: WebListBox with DataSource - multiple usage

Targets Web
1

I am looking for some advice/thoughts/opinions from experienced Xojo people.

WebApp has DataSource class that can be used with WebListBox and Postgres Database to show some data.
WebApp has complex WebPage that consists of several WebContainers, each container has at least 1 (one) WebListBox that is using DataSource.
The DataSource in each WebContainer shows as the widget in the “bottom shelf”, it has unique name.
Each WebListBox has different query (typically using some parameters).

Problem:
When testing the WebApp on my machine I often get errors in DataSource.RawData method, the error is about rs (RowSet) having different columns from expected columns, it looks as if the query getting count() is confused with the query getting data.
If I run the same compiled code through the browser off the web server (that has database server on local network) then I don’t get to see these errors, the data shows properly.

So my question:
Could this be caused by network latency?

My other question:
Can I use single DataSource class as Super in various WebContainers? (this is what I assume I can do)
Or shall I create separate subclasses from DataSource and then use them as Super in various WebContainers?

Basically, I am wondering how instantiation of the DataSource properties really works in this scenario. Perhaps there is some source of information on this topic somewhere but I couldn’t find is.

2

That doesn’t sounds like a network latency issue, unless multiple WebListBox are sharing a single WebDataSource and are able to modify it. Do you have different WebDataSource class instances for each WebListBox or how are you doing it?

You can attach a sample project here in the forum if you compress it with zip.

Yes. You can even add the WebDataSource interface to the WebContainer, it doesn’t need to be a separate class, that will ensure each container has its own instance of a WebDataSource (I’m not sure if that’s the issue you’re seeing)