我用ADOStoredProc1连接的存储过程:
CREATE PROCEDURE haoliao
@lsh as varchar(20),@cbh as varchar(10)
AS
update wlda set kcsl=kcsl-pf.yl*xfjlb.ls_sl from wlda,pf,xfjlb where xfjlb.ls_sx='3' and pf.cpbh=@cbh and wlda.wlbh=pf.wlbh and xfjlb.lsh=@lsh
insert into xfwh select xfjlb.ls_zh, getdate(), xfjlb.ls_cbh, xfjlb.ls_sl, pf.wlbh, pf.yl,wlda.ckpjdj, xfjlb.ls_cw, xfjlb.ls_cw, xfjlb.lsh
from xfjlb, pf,wlda
where xfjlb.ls_sx='3'and pf.cpbh=@cbh and xfjlb.lsh=@lsh and wlda.wlbh=pf.wlbh and xfjlb.ls_cbh=@cbh
GO
一激活怎么老师提示不能返回结果集什么意思
CREATE PROCEDURE haoliao
@lsh as varchar(20),@cbh as varchar(10)
AS
update wlda set kcsl=kcsl-pf.yl*xfjlb.ls_sl from wlda,pf,xfjlb where xfjlb.ls_sx='3' and pf.cpbh=@cbh and wlda.wlbh=pf.wlbh and xfjlb.lsh=@lsh
insert into xfwh select xfjlb.ls_zh, getdate(), xfjlb.ls_cbh, xfjlb.ls_sl, pf.wlbh, pf.yl,wlda.ckpjdj, xfjlb.ls_cw, xfjlb.ls_cw, xfjlb.lsh
from xfjlb, pf,wlda
where xfjlb.ls_sx='3'and pf.cpbh=@cbh and xfjlb.lsh=@lsh and wlda.wlbh=pf.wlbh and xfjlb.ls_cbh=@cbh
GO
一激活怎么老师提示不能返回结果集什么意思
解决方案 »
- Delphi7 中是否有信号灯的组件啊
- 使用BDE能不能直接获取数据库表中的某一条记录的一个字段的值?
- 数据导出问题?急救!
- 怎么读出paradox里的数据,把数据写进excel里?
- DELPHI问题:如何实现Grid录入时,显示多列下拉列表?(不是LookUp字段方式)
- 小问题!散分
- 现在大家用delphi5还是delphi6啊?来者有分!!!
- 本人的delphi6论坛已开通(www.delphi6.onchina.net),欢迎大家惠顾
- 诚招项目开发伙伴
- delphi fastreport打印条码识别困难?
- I am finding the Canon SDK with delphi RelCtrl's sample
- Delphi如何静态和动态的调用动态链接库?赐教,在线等
query.execsql
stroedproc.execute