我调用存储过程的时候总是报错,提示找不到参数,不知道什么原因我建的存储过程是这样,不知道有没有什么错CREATE procedure infor
@singlenumber varchar(20),
@singlestate varchar(50),
@consiname varchar(50),
@goodsname varchar(50),
@amount bigint,
@arrivate varchar(50),
@recedate datetime,
@piondate datetime,
@leastdate datetime,
@noremit varchar(50),
@consinphone varchar(50)
as
insert into information values(@singlenumber,@singlestate,@consiname,@goodsname,@amount,@arrivate,@recedate,@piondate,@leastdate,@noremit,@consinphone)
insert into amw values(@singlenumber,@singlestate,@consiname,@goodsname,@amount,@arrivate,@recedate,@piondate,@leastdate,@noremit,@consinphone)
GO
@singlenumber varchar(20),
@singlestate varchar(50),
@consiname varchar(50),
@goodsname varchar(50),
@amount bigint,
@arrivate varchar(50),
@recedate datetime,
@piondate datetime,
@leastdate datetime,
@noremit varchar(50),
@consinphone varchar(50)
as
insert into information values(@singlenumber,@singlestate,@consiname,@goodsname,@amount,@arrivate,@recedate,@piondate,@leastdate,@noremit,@consinphone)
insert into amw values(@singlenumber,@singlestate,@consiname,@goodsname,@amount,@arrivate,@recedate,@piondate,@leastdate,@noremit,@consinphone)
GO
解决方案 »
- 高分悬赏:C代码转为Delphi,在线等.
- 如何判断stringgrid中是否存在重复值?
- 为什么在ORACLE的WORKSHEET下面运行能够显示数据,但是在DELPHI里面用DATAGRID就显示不了,??????
- 怎么编程实现对交换机端口的控制?(允许和禁止使用)
- 请问如何能屏蔽dephi的源码?一个做好的form,供用户继承,但不提供源码,怎样做到?
- delphi6.0下套打的问题,急需
- Windows内存管理机制的不惑
- 请高手赐教!!关于短信平台的设计问题!
- help,请大家指点
- 怎样令Delphi编译出来的EXE文件小点??
- 高手进来哦,文本导入数据库求助哦
- !!!!!!100分求奇思妙想编程序这本书电子版?=====
改成
insert into information (各字段名......) values(@singlenumber,@singlestate,@consiname,@goodsname,@amount,@arrivate,@recedate,@piondate,@leastdate,@noremit,@consinphone)2个都改一下试试
dm.jiaofeiProc.Close;
dm.jiaofeiProc.ProcedureName:='renyuan_p';
dm.jiaofeiProc.Parameters.Refresh;
dm.jiaofeiProc.Parameters.ParamByName('@id').Value:=edit11.text;
dm.jiaofeiProc.Parameters.ParamByName('@name').Value:=edit1.Text;
dm.jiaofeiProc.Parameters.ParamByName('@sex').Value:=combobox1.Text;
dm.jiaofeiProc.Parameters.ParamByName('@carid').Value:=edit2.Text;
dm.jiaofeiProc.Parameters.ParamByName('@birth').Value:=edit3.Text;
dm.jiaofeiProc.Parameters.ParamByName('@huji').Value:=combobox2.Text;
dm.jiaofeiProc.Parameters.ParamByName('@mobile').Value:=edit5.Text;
dm.jiaofeiProc.Parameters.ParamByName('@homephone').Value:=edit6.Text;
dm.jiaofeiProc.Parameters.ParamByName('@contact').Value:=edit4.Text;
dm.jiaofeiProc.Parameters.ParamByName('@otherphone').Value:=edit7.Text;
dm.jiaofeiProc.Parameters.ParamByName('@driver').Value:=combobox3.Text;
dm.jiaofeiProc.Parameters.ParamByName('@drivertime').Value:=combobox5.Text;
dm.jiaofeiProc.Parameters.ParamByName('@control').Value:=StatusBar1.Panels[1].Text+' '+time1;
dm.jiaofeiProc.Parameters.ParamByName('@ksid').Value:=edit9.Text;
dm.jiaofeiProc.Parameters.ParamByName('@pass').Value:=edit10.Text;
dm.jiaofeiProc.Parameters.ParamByName('@factory').Value:=edit15.Text;
dm.jiaofeiProc.Parameters.ParamByName('@education').Value:=combobox4.Text;
dm.jiaofeiProc.Parameters.ParamByName('@pinyong').Value:=combobox6.Text;
dm.jiaofeiProc.ExecProc;
然后看代码中有没有给所有的参数赋值?
最后赋值。