Dropdown Control Refresh problems

[golf212]

I have a screen1 with a dropdown control that references an array popup for the elements. The array is filled using a query:

DIMEN a_popup[1]
SELECT desc FROM dbcode INTO ARRAY a_popup
**(dbcode.desc is a text field)

Screen1 calls a subscreen Screen2, whose function is to allow the user to insert, edit, or delete records in the dbcode table.

On return from Screen2, a_popup is reloaded with a query to refresh the dropdown control with any changes that might have been made to dbcode table.

Problem: the dropdown control still displays the original content of table dbcode, even though dbcode has been edited. The only way to get the dropdown refreshed to the new data is to exit screen1 to some other screen in the system (not modal) then return.

I have tried closing dbcode and re-using, releasing a_popup and doing another DIMEN to create. Nothing seems to work. I am missing something but I can’t seem see it. Any ideas?

John

 

[TamarGranor]

It's a long, long time since I've done this sort of thing, but try issue SHOW GET for the dropdown after you refill the array.

Tamar

 

[golf212]

Thank for the reply Tamar, sorry so long for the reply, but got totally sidetracked this week. Tried the "SHOW GETS" but that wasn't my problem. Turned out to a coding problem; the refresh code wasn't being executed at all. Sometimes you need to check the obvious first!

John