I know this is simple, but I am missing something. I am putting together a screen with 2 combo boxes that are related. When the user changes the value in the first combo box I want the following steps to happen.
Retrieve the set of new records and show those new records in the second combo box. When I first go execute the fill code everything works fine. The second time I get the following message "**No Record Available (91)". Below is the code I am using to fill the combo box.
RUN sms/tb/lib/state_list.p ON hServer
(INPUT sms.lib.clientSession:sessionId,
INPUT countryCode,
OUTPUT TABLE-HANDLE thEntries).
IF qhEntries:PREPARE-STRING = ? THEN
DO:
qhEntries:ADD-BUFFER(thEntries:DEFAULT-BUFFER-HANDLE).
qhEntries:QUERY-PREPARE("FOR EACH " + thEntries:NAME).
END.
bsEntries:HANDLE = qhEntries.
Can someone point me in the right direction? Thank you.
I assume, that you need to open the query first: qhEntries:QUERY-OPEN() .
Then you need to call RefreshAll() on the related binding source. Or set the AutoSync property = True.
Thank you that helped. I had resolved the problem, but not in the right way.