DataModule1.query1.Close;
DataModule1.query1.SQL.Clear;
DataModule1.Query1.SQL.Add('select * from FangWuSuoYouRen_table where Bianhao=' + sBianhao );
DataModule1.query1.Open;
if ( not DataModule1.query1.IsEmpty ) then
begin
suiEditFangWu_No.Text:=DataModule1.query1.FieldByName('FangWu_No').AsString;
suiEditLouCeng_No.Text:=DataModule1.query1.FieldByName('LouCeng_No').AsString;
suiEditFangJian_No.Text:=DataModule1.query1.FieldByName('FangJian_No').AsString;
suiEditSuoYouRen.Text:=DataModule1.query1.FieldByName('SuoYouRen').AsString;
suiComboBoxXiaoqu_No.Text:=DataModule1.query1.FieldByName('Xiaoqu_No').AsString;
suiComboBoxDanyuan_No.Text:=DataModule1.query1.FieldByName('Danyuan_No').AsString;
end;
DataModule1.query1.Close;其中Bianhao为主键
DataModule1.query1.SQL.Clear;
DataModule1.Query1.SQL.Add('select * from FangWuSuoYouRen_table where Bianhao=' + sBianhao );
DataModule1.query1.Open;
if ( not DataModule1.query1.IsEmpty ) then
begin
suiEditFangWu_No.Text:=DataModule1.query1.FieldByName('FangWu_No').AsString;
suiEditLouCeng_No.Text:=DataModule1.query1.FieldByName('LouCeng_No').AsString;
suiEditFangJian_No.Text:=DataModule1.query1.FieldByName('FangJian_No').AsString;
suiEditSuoYouRen.Text:=DataModule1.query1.FieldByName('SuoYouRen').AsString;
suiComboBoxXiaoqu_No.Text:=DataModule1.query1.FieldByName('Xiaoqu_No').AsString;
suiComboBoxDanyuan_No.Text:=DataModule1.query1.FieldByName('Danyuan_No').AsString;
end;
DataModule1.query1.Close;其中Bianhao为主键
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货