Xojo2024R4: updating selected rows in WebListBox using DataSource - how to?

Targets Web
1

WebPage showing WebListBox with the timer refreshing the list every minute, the WebListBox is using DataSource. The user can select multiple entries, open WebDialog, enter comment and hit Save button which updates records in database and closes WebDialog. The expectation is that the comment column will now show freshly entered comment.

I can’t use CellTextAt to update relevant comment cell in the selected rows.
I can re-run the query but that is not very efficient.

How do I update text of the cell in selected row in the WebListBox that is using DataSource class?

2

have you updated this comment via RowSet EditRow / SaveRow ?

3

I think you’re probably looking for the WebListbox.ReloadData function.

The documentation says:

Reloads the data into the WebListBox.

This is useful with the data in the WebListBox comes from a WebDataSource and that data has changed since it was last loaded into the WebListBox.

In this instance, I would think the database should outperform any Xojo-side caching you could implement. The Xojo Framework is going to paginate and limit the query to just the visible rows. If the query really is inefficient, we can ping in some database experts.

4

Markus, how is this supposed to redraw the row on the screen?

5

I use ReloadData function all the time when rebuilding the web list box, this is the only way I know of to use to refresh the list on the screen after editing value in the selected list row.

I wish I could simply refresh the cell in the selected row instead but that is not possobile with DataSource. The query behind the list is optimized but there are many elements and the query is pretty complex, re-running the query from the database to pull value in the column of few selected rows seems to be an overkill and the only option I can use.

6

There is always the option to file a Feature Request.
Ricardo may have a better idea on how it works and what he can do to make it better.