s := '编号=姓名';iPos := Pos('=', s); //取等号的位置s := Copy(s, 1, iPos - 1);// 现在, s = '编号'
procedure TForm1.FormCreate(Sender: TObject); begin combobox1.Items.Add('编号=姓名'); showmessage(combobox1.Items.Values['编号']); end;
query.sql.text:='select 编号,姓名 from 表'; query.open; while not query.eof do begin combobox1.items.add(query.fieldvalues['编号']+'='+query.fieldvalues['姓名']); query.next; end;query1.sql.text:='insert into 表2(编号) values('+combobox1.Items.Values['编号']+')'; query2.execsql;
begin
combobox1.Items.Add('编号=姓名');
showmessage(combobox1.Items.Values['编号']);
end;
query.open;
while not query.eof do
begin
combobox1.items.add(query.fieldvalues['编号']+'='+query.fieldvalues['姓名']);
query.next;
end;query1.sql.text:='insert into 表2(编号) values('+combobox1.Items.Values['编号']+')';
query2.execsql;