读书人

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

发布时间: 2012-04-04 16:38:51 作者: rapoo

急~!!!分数全给了~数据库操作问题
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'','附近有错误'

[解决办法]

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

读书人网 >.NET

热点推荐