Avoid duplicates in dddw in powerbuilder

Question

i have a created a DropDownDataWindow in PowerBuilder, the list has zip codes from a database table... but it has many duplicates and more like that for example,

... ans so on ,

my script is the following

datawindowchild child_data

dw_zipcontact_filter.insertrow(0)
if dw_zipcontact_filter.getchild( 'zipcontact', child_data ) = 1 then
 child_data.settransobject( SQLCA )
 child_data.retrieve( ) 
 child_data.insertrow(1)
 child_data.setitem( 1, 'id', 'ALL zip codes' )
 child_data.setitem( 1, 'zip', 'ALL zip codes' )
 child_data.selectrow( 0, false )   
end if

i want to show my list like that,

01720
01730

.... and so on,

how can i do that?? i was wondering if anyone can help me, any help would be really appreciated..

Thank you in advance

score 1 · Accepted Answer · answered Nov 09 '15 at 12:56

You need to create the SELECT statement for the datawindow object used as the DDDW in your 'zipcontent' column to only retrieve a distinct list. You should also set the sort order (either in the SQL itself or in the sort option of the datawindow object).

score 0 · Answer 2 · answered Nov 09 '15 at 13:22

With the great help of Matt Balent, i solved it and here is the solution analytically,

Open the DDDW's DataWindow Painter. Go to the SQL source. Under the Design menu, select "Convert to Syntax" if you're not already there, and either use the SELECT DISTINCT clause or a GROUP BY clause.,

Avoid duplicates in dddw in powerbuilder

2 Answers2