combobox.Clear; query.Frist; while not query.Eof do begin comboBox.Items.Add(query.FieldByName('姓名').asString); query.Next; end;
Query.SQL.Clear; Query.SQL.Add('select 姓名 from“表名”where 部门=''经营部'''); Query.Active:=True; Query.First; ComboBox.Items.Clear; while not Query.Eof do begin ComboBox.Items.Add(Query.FieldBYName('姓名').AsString); Query.Next; end;
while not Query.Eof do begin ComboBox.Items.Add(Query.FieldBYName('姓名').AsString); Query.Next; end;
Query.SQL.Clear; Query.SQL.Add('select 姓名 from“表名”where 部门=:aa); parameters.parambyname('aa').value:='经营部'; Query.oen; Query.First; ComboBox.Items.Clear; while not Query.Eof do begin ComboBox.Items.Add(Query.FieldBYName('姓名').AsString); Query.Next; end;
query.Frist;
while not query.Eof do
begin
comboBox.Items.Add(query.FieldByName('姓名').asString);
query.Next;
end;
Query.SQL.Add('select 姓名 from“表名”where 部门=''经营部''');
Query.Active:=True;
Query.First;
ComboBox.Items.Clear;
while not Query.Eof do
begin
ComboBox.Items.Add(Query.FieldBYName('姓名').AsString);
Query.Next;
end;
begin
ComboBox.Items.Add(Query.FieldBYName('姓名').AsString);
Query.Next;
end;
Query.SQL.Add('select 姓名 from“表名”where 部门=:aa);
parameters.parambyname('aa').value:='经营部';
Query.oen;
Query.First;
ComboBox.Items.Clear;
while not Query.Eof do
begin
ComboBox.Items.Add(Query.FieldBYName('姓名').AsString);
Query.Next;
end;