with adoquery1 do begin close;sql.clear; sql.add('select distinct F01 from aTableName order by F01'); open; while not eof do begin listbox1.items.add(fieldByName('F01').asstring); next; end; end;
begin ListBox1.Clear; with ADOQuery1 do begin SQL.Text := 'select distinct F01 from aTableName order by F01'; Open; while not Eof do begin ListBox1.Items.Add(FieldByName('F01').AsString); Next; end; Close; &nbs