PopupMenu Ascending Order?

RicSum · **Posted:** Fri May 17, 2013 12:11 pm

Hi,
My popupmenu is populated from a database and the code below works perfectly, HOWEVER,
would it be possible to modify the code in order to cause the entries in the popupmenu to be displayed in Ascending order ?

Dim stSQL as String

If db8.Connect = True Then
  stSql = "SELECT Sonames FROM SettingsTable"
  rs8 = dB8.SQLSelect(stSql)
  
  if rs8 = nil then
    msgbox "Problem with Database!"
    
  else
    while not rs8.EOF
      win_Add.PopupMenu2.AddRow rs8.Field("Sonames").StringValue
      rs8.MoveNext
    wend
  end
end if
rs8.Close

Thank you all in advance.

timhare · **Posted:** Fri May 17, 2013 12:31 pm

Add an ORDER BY clause to your sql statement to retrieve them in the order you want.

select sonames from SettingsTable order by sonames

RicSum · **Posted:** Fri May 17, 2013 12:53 pm

Duhhhh,
Thanks Tim

	Real Software Forums The forum for Real Studio and other Real Software products.
[ REAL Software Website \| Board Index ]

Real Software Forums

PopupMenu Ascending Order?