+ -
当前位置:首页 → 问答吧 → 急~!!!分数全给了~数据库操作问题

急~!!!分数全给了~数据库操作问题

时间:2011-12-14

来源:互联网

use xuejiguanli
go
create proc MR_Insert_XuanXiu
@XueHao varchar(20),
@KeChenHao varchar(20),
@FenShu numeric(4,1)
as
begin
insert into XuanXiu(XueHao,KeChenHao,FenShu)
  values(@XueHao,@KeChenHao,@FenShu)
end
go
  

procedure TForm_chengji.btn1Click(Sender: TObject);
begin
  with ADOQuery1 do
  begin
  Close;
  SQL.Clear;
  SQL.Add('MR_Insert_XuanXiu:XueHao,:KeChenHao,:FenShu');
  Parameters.ParamByName('XueHao').Value := edt1.Text;
  Parameters.ParamByName('KeChenHao').Value := edt2.Text;
  Parameters.ParamByName('FenShu').Value := edt3.Text;
  ExecSQL;
  end;
  ShowMessage('添加成功');
  Close;
end;



运行报错 ProjectProject raised exception class eoleexception with message'','附近有错误'

作者: HCDA_HCDP   发布时间: 2011-12-14

SQL.Add('Exec MR_Insert_XuanXiu :XueHao,:KeChenHao,:FenShu');

作者: jzy_QQ_396638838   发布时间: 2011-12-14

Delphi(Pascal) code
SQL.Add('Exec MR_Insert_XuanXiu :XueHao,

作者: kaikai_kk   发布时间: 2011-12-14