from1 btn1 qry1 ds1
fxiugai edt(若干) qry2 ds2
按btn1 from2show
procedure TForm1.btn2Click(Sender: TObject); begin
Str:=qry1.fieldbyname('sno').AsString;
Application.CreateForm(TFxiugai,Fxiugai);
Fxiugai.ShowModal;
Fxiugai.Free;
end;
procedure TFxiugai.btn2Click(Sender: TObject);
begin
Close;
end; procedure TFxiugai.FormCreate(Sender: TObject); var
a,b,c,d,e,f:string;
begin qry_xg.Connection:=DataModule2.con1;
qry_xg.Active:=True;
with qry_xg do
begin
Close;
SQL.Clear;
SQL.Text:='select * from student where sno=:a';
Parameters.ParamByName('a').Value:=Form1.str;
Open;
qry_xg.FieldByName('sno').Value:=strngfld_xgsno.AsString;
qry_xg.FieldByName('sname').Value:=strngfld_xgsname.AsString;
qry_xg.FieldByName('sgentle').Value:=strngfld_xgsgentle.AsString;
qry_xg.FieldByName('sage').Value:=qry_xgsage.AsString;
qry_xg.FieldByName('sbirth').Value:=qry_xgsbirth.AsString;
qry_xg.FieldByName('sdept').Value:=strngfld_xgsdept.AsString;
edit.text:=qryxg.fieldbyname('sno').asstring;
end; end;
意思就是把from1的值传到fxiugai 上面去
老是报错!赋值到 edit 赋不上啊?
帮忙指导指导啊!~
fxiugai edt(若干) qry2 ds2
按btn1 from2show
procedure TForm1.btn2Click(Sender: TObject); begin
Str:=qry1.fieldbyname('sno').AsString;
Application.CreateForm(TFxiugai,Fxiugai);
Fxiugai.ShowModal;
Fxiugai.Free;
end;
procedure TFxiugai.btn2Click(Sender: TObject);
begin
Close;
end; procedure TFxiugai.FormCreate(Sender: TObject); var
a,b,c,d,e,f:string;
begin qry_xg.Connection:=DataModule2.con1;
qry_xg.Active:=True;
with qry_xg do
begin
Close;
SQL.Clear;
SQL.Text:='select * from student where sno=:a';
Parameters.ParamByName('a').Value:=Form1.str;
Open;
qry_xg.FieldByName('sno').Value:=strngfld_xgsno.AsString;
qry_xg.FieldByName('sname').Value:=strngfld_xgsname.AsString;
qry_xg.FieldByName('sgentle').Value:=strngfld_xgsgentle.AsString;
qry_xg.FieldByName('sage').Value:=qry_xgsage.AsString;
qry_xg.FieldByName('sbirth').Value:=qry_xgsbirth.AsString;
qry_xg.FieldByName('sdept').Value:=strngfld_xgsdept.AsString;
edit.text:=qryxg.fieldbyname('sno').asstring;
end; end;
意思就是把from1的值传到fxiugai 上面去
老是报错!赋值到 edit 赋不上啊?
帮忙指导指导啊!~
a,b,c,d,e,f:string;
begin qry_xg.Connection:=DataModule2.con1;
qry_xg.Active:=True;
with qry_xg do
begin
Close;
SQL.Clear;
SQL.Text:='select * from student where sno=:a';
Parameters.ParamByName('a').Value:=Form1.str;
Open;
end;
edt1.Text:=qry_xg.fieldbyname('sno').AsString;
edt2.Text:=qry_xg.fieldbyname('sname').AsString;
edt3.Text:=qry_xg.fieldbyname('sgentle').AsString;
edt4.Text:=qry_xg.fieldbyname('sage').AsString;
dtp1.DateTime:=qry_xg.fieldbyname('sbirth').AsDateTime;
edt5.Text:=qry_xg.fieldbyname('sdept').AsString;
end; 上面就出来了!~呵呵谢谢大家啊1`