Database Driving Selection Box

[devinst]

Is there a way to limit when a database driven selection box will be refreshed? The listing is part of a selection criteria for a grid and only needs to be refreshed when the button for a change or add has been clicked. Currently it refreshes with each click on the screen including on the grid.
Thanks.!!!

[Scott Klement]

Normally, a database-driven widget will only be reloaded when the screen is displayed (such as when RPG does an EXFMT or READ operation on a record format.) Each time the RPG program does this, it's necessary to re-load the widget because the screen is cleared and re-drawn at that point.

I don't know why it'd re-load whenever you click anywhere on the screen, unless you've coded it to return control to the RPG when a click occurs? Or if you've written JavaScript to re-load from the database whenever a click occurs?

Can you tell us more about why a click might do this in your application?

[devinst]

The grid gives the user a list of master records. A section below the grid is used to display detail data when a record is clicked in the grid. This, of course, is sending the click to the program so that it can get the detail information and redisplay the screen.

What you are saying does make sense now. I guess I was just hoping for some type of indicator that would instruct the field to retain the data it has.
Thanks for the insight.!!!