We have a non database list box to provide a parameter for a form's where clause ( WHERE TO_CHAR(logdate,'YYYY') = :year_dd)
in the WHEN-LIST-CHANGED trigger, we CLEAR_BLOCK(NO_VALIDATE)
and ENTER_QUERY
So far so good. ENTER_QUERY quite correctly clears the form. BUT we do not want the value in the list cleared. I have tried storeing the list value to a global and re-assigning to the list box in several places. Either nothing happens, or an error message occours.
What is the Oracle equivilant to REFRESH? Or where should I restore the value to the list box?