Powerbuilder Window/Datawindow Field Display Problem

[Former Member]

I am using Powerbuilder 10.5. I have a window has a field (field 1) which contains a datawindow (dw_2) which contains a field (field 2) which has a style type of DropDownDW. The field is supposed to retrieve values from a stored procedure which is linked to field 2. When adding a record on the window, the values should be available for selection when clicking on field 1; the retrieval works - clicking on the field opens the drop down datawindow and the values are there. However, field 1 is supposed to display the contents of the display column for field 2 when retrieving an existing record on the window, and it does not do that. The data is in the database, but does not appear.

This is the code I have in the constructor for dw_2:

this.triggerevent("ue_retrieve")

This is the code I have in the ue_retrieve for dw_2:

DataWindowChild dwc

Integer li_prgrm_id, rtncode

long ll_count

this.GetChild('code_description', dwc)

dwc.SetTransObject(SQLCA)

dwc.Retrieve(Application.uf_Get_Preferred_Language(), 663)

This is the code I have in a user function to set items. The third setitem is what I’m trying to accomplish:

dw_appdate.setitem(1, "ba_aplctn_dte", date(ps_ba_aplctn_dte)) (works)

dw_comments.setitem(1, "ba_cmnt_txt", ps_comments) (works)

dw_2.setitem(1,"cde_vl_sqn", ii_claim_src_typ_cde) (does not work; ii_claim_src_typ_cde has a value)

I have screenshots to give you and idea of what is happening. I am unable to attach the screenshot file to this post, but if I can be provided with an email address, I can send the screenshot file directly. My email is jiml.macdonald@vac-acc.gc.ca. Any help appreciated.

Thanks

James MacDonald

[former_member190719]

Well, it's been a while, but you might get better response if you post this over in the PowerBuilder Developer Center.