var query : TAdoQuery; ... combobox1.items.clear; query.close; query.sql.clear; query.sql.add('SELECT DISTINCT fieldname FROM tablename'); try query.open; while not query.eof do begin combobox1.items.add(query.fieldbyname('fieldname').asstring); query.next; end; finally query.close; end; end;
query : TAdoQuery;
...
combobox1.items.clear;
query.close;
query.sql.clear;
query.sql.add('SELECT DISTINCT fieldname FROM tablename');
try
query.open;
while not query.eof do
begin
combobox1.items.add(query.fieldbyname('fieldname').asstring);
query.next;
end;
finally
query.close;
end;
end;