I have a html launch page that has 20+ list boxes on it and it is taking too long to load before the user can ever do anything. I’m trying to find a way to populate each list box only when needed. When one list box is clicked, I’d list to execute a focexec to populate the next one needed, but only when it is needed? Do you know of a way to do this? I can build the url required but I’m not sure how to execute it.

You might want to look into chaining? This will populate one listbox based on a "chained" listbox's choice.

Hope this helps.

Bob,

We have a number of launch pages that each have many comboboxes, each with multi-select allowed.
We've also found that when developed with the ususal IBI tools, background processes are run before painting the launch page that query the required tables to obtain the values to put into the launch page's combo/dropdownselect boxes. To populate some of our boxes required querying 1.5M row tables, and this, as you've found slows displaying the page.

Our solution involved a multi-step RCaster job run overnight that developes the content of all such boxes for our whole population of launch pages. For each select box the RCaster job produces a boxname.htm file that is included into the lauch page with "!IBI.FIL.boxname;".
This really speeds up the loading of the launch page (except for our one page that includeds a combobox with 12K rows!).

This solution is only valid for lists whose content need not be 'real time', but even that demand can be approximately satisfied by running the RCaster job more often than once a day; hourly perhaps.

If you're interested in this solution I can post the text of the overnight job, etc.