title: Populate Drop Down List Box (DDLB) with two values in PowerBuilder
body: <p>I've created a Drop Down List Box (DDLB) in my window (I'm using PowerBuilder 10.5). Once I would call my function, the DDLB would fill with all the different cities from my table. This is the code I've used:</p>
  
  <pre><code>FOR li_i=1 TO ii_br_red
  ls_city = dw_city.GetItemString(li_i, 'city')
  IF ddlb_city.FindItem(ls_city, 1) = -1 THEN 
  ddlb_city.AddItem(ls_city) END IF; NEXT
  </code></pre>
  
  <p>Next part of the code is in the ddlb "selectionchanged" event...</p>
  
  <pre><code> dw_city.SetFilter("city = '" + this.text + "'")
   dw_city.Filter()
  </code></pre>
  
  <p>This works great, and after calling my function (via click on a command button) I'd get a list of all different cities in my table, ex. </p>
  
  <pre><code>Paris
  London
  New York
  Washington
  </code></pre>
  
  <p>No town would be listed twice.
  What I need to do now is add a country next to every city in my DDLB. So that after clicking my command button I would get this in my DDLB:</p>
  
  <pre><code>Paris (France)
  London (GB)
  New York (USA)
  Washington (USA)
  </code></pre>
  
  <p>Any advice? Thanks in advance...</p>
  
  <p>SECOND QUESTION, similar to this subject: I have an SQL code:</p>
  
  <pre><code>SELECT distinct name FROM table1;
  </code></pre>
  
  <p>This gives me 8 different names. What I want to do is fill another DDLB, ddlb_1 with these names, but this must occur on the open event of my program. This is what I've written in the open event of my program:</p>
  
  <pre><code>string ls_name
  SELECT distinct name INTO :ls_name FROM tabel1;
  ddlb_1.AddItem(ls_name)
  </code></pre>
  
  <p>But this only gives me the first name. I'm guessing I need some kind of count, but I just can't pull it off.</p>