Can we load data on demand?

When grid is used to represent data in the DB (ex. a table),
there are potentially more than thousands of rows (ex. 100K).
Loading the complete data set would not be practical.
Viewing area would be just a few number of rows.
Can the grid load only the viewable rows on demand?

There is a 'paging patch' which can give some inspiration on this. In theory, yes, the grid requests data (from the data model) on demand and data model can, in turn, download data asynchronously. But the standard grid does not do anything like that.

I have a grid set up with the xml table. I find that I can do:

table.setProperty("URL", "http://test.xml.php");
table.request();

and the grid that its attached to will automaticaly update. So, you could put that in a function and call it from a form button or whatever, passing in your page value.

If you are loading thousands of rows then I would think that you would need to add some searching ability to ActiveWidget. I am thinking about putting together something that would allow paging, ODBC support (server-side) and search/filtering functionality. Sort of a cross between GenericDB and ActiveWidget.