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;
我就改一下1楼兄弟的吧,对新手有点用吧。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; 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; end; end;支持楼上的,一般都是这么处理的。比较明了。
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;
我就改一下1楼兄弟的吧,对新手有点用吧。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;
end;
end;
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;
end;
end;支持楼上的,一般都是这么处理的。比较明了。