PowerBuilder dropdowndatawindow insertrow changes Display Column value

1
votes

Working with PowerBuilder 11.5.

I have a datawindow (dw) consuming a dropdowndatawindow (dddw). I am performing dddw.insertrow (0) in the constructor of the dw, and then doing dw.insertrow().

The issue I am having is that the value of "Display Column" for the dddw control in the dw is being changed to the value of the "Data Column" at some point, i.e. the resulting application is showing the data (primary key) instead of a formatted string value (the "Display Column" I had selected).

I am also retrieving the value of the "Display Column" property after the insertrow and retrieve calls, and it is still defined as I had set it initially (i.e. unchanged), however when the data is displayed, the "Data Column" values are shown.

Any pointers to why this is happening?

Thanks

1
powerbuilderdatawindow
Are you sure that the value of the column in dw actualy matches a value of a line in the dddw? Do you make some dynamic filtering in the dddw? - Seki
Is the dddw retrieving any rows? what's in it when you drop it down? - Hugh Brackett
@HughBrackett Yes. I solved the issue by eliminating the dddw altogether, and displaying one value in a Column control (text box). - Usering

1 Answers

1
votes

PB shows "Data" instead of "Display" when it can't find exact match of DW's value to DDDW's data.

Thought, your "Data column" has "char(...)" type?

One of possible solution - switch to numeric (I prefere "long") type instead of strings as "Data". PB much more precise with numbers.