各位我写了一个存储过程是
CREATE PROCEDURE wfx_khzc @cstcode varchar (20) AS
--jolly 2005.3.14 获得某个客户的包装物暂存
if exists (select * from sysobjects where id = object_id(N'wfx_bzhzc') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
print 'deleted wfx_bzhzc'
drop table wfx_bzhzc
end
--start
SELECT WrsInfo.SwrsName AS wrsname, ISNULL(view_pqr_hkd.物资数量,0) AS zc
into wfx_bzhzc
FROM WrsInfo LEFT OUTER JOIN
view_pqr_hkd ON dbo.WrsInfo.Swrscode =view_pqr_hkd.物资编码
where dbo.WrsInfo.SWKDCode LIKE '003%' and dbo.WrsInfo.Swrscode in (select 物资编码 from view_pqr_hkd) and view_pqr_hkd.审核时间<>'' and view_pqr_hkd.是否核销='0'
and view_pqr_hkd.是否废票='0' and( view_pqr_hkd.回空类型='6' or view_pqr_hkd.回空类型='0' ) and view_pqr_hkd.客户编码=@cstcode
GO我又在程序中写了一个查询
'给客户包装物暂存赋值
Sql = " wfx_khzc'" & khdh & "'"
goConnect.Execute Sql, adCmdStoredProc
Sql = "select wrsname,sum(zc) from wfx_bzhzc group by wrsname"
rs.Open Sql, goConnect, adOpenForwardOnly, adLockReadOnly
If rs.RecordCount > 0 Then
rs.MoveFirst
Do
rtxt.Text = rtxt.Text & " " & rs.Fields(0) & " " & rs.Fields(1)
rs.MoveNext
Loop While Not (rs.BOF Or rs.EOF)
Else
rtxt.Text = "该客户当前没有包装物暂存!"
End If
goConnect.Execute "drop table wfx_wzhzc"
rs.Close
Set rs = Nothing
这段程序第一次执行挺好可是执行第二遍时
语句goConnect.Execute "drop table wfx_wzhzc" 报wfx_wzhzc无效的错误请各位帮帮忙说说原因谢了。
CREATE PROCEDURE wfx_khzc @cstcode varchar (20) AS
--jolly 2005.3.14 获得某个客户的包装物暂存
if exists (select * from sysobjects where id = object_id(N'wfx_bzhzc') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
print 'deleted wfx_bzhzc'
drop table wfx_bzhzc
end
--start
SELECT WrsInfo.SwrsName AS wrsname, ISNULL(view_pqr_hkd.物资数量,0) AS zc
into wfx_bzhzc
FROM WrsInfo LEFT OUTER JOIN
view_pqr_hkd ON dbo.WrsInfo.Swrscode =view_pqr_hkd.物资编码
where dbo.WrsInfo.SWKDCode LIKE '003%' and dbo.WrsInfo.Swrscode in (select 物资编码 from view_pqr_hkd) and view_pqr_hkd.审核时间<>'' and view_pqr_hkd.是否核销='0'
and view_pqr_hkd.是否废票='0' and( view_pqr_hkd.回空类型='6' or view_pqr_hkd.回空类型='0' ) and view_pqr_hkd.客户编码=@cstcode
GO我又在程序中写了一个查询
'给客户包装物暂存赋值
Sql = " wfx_khzc'" & khdh & "'"
goConnect.Execute Sql, adCmdStoredProc
Sql = "select wrsname,sum(zc) from wfx_bzhzc group by wrsname"
rs.Open Sql, goConnect, adOpenForwardOnly, adLockReadOnly
If rs.RecordCount > 0 Then
rs.MoveFirst
Do
rtxt.Text = rtxt.Text & " " & rs.Fields(0) & " " & rs.Fields(1)
rs.MoveNext
Loop While Not (rs.BOF Or rs.EOF)
Else
rtxt.Text = "该客户当前没有包装物暂存!"
End If
goConnect.Execute "drop table wfx_wzhzc"
rs.Close
Set rs = Nothing
这段程序第一次执行挺好可是执行第二遍时
语句goConnect.Execute "drop table wfx_wzhzc" 报wfx_wzhzc无效的错误请各位帮帮忙说说原因谢了。
解决方案 »
- 用滚动条调整字的颜色的代码
- 100分在线等候:请问wininet.dll中哪个函数能获取到FTP上指定的文件大小的?
- 一个多线程问题-->>在VB中怎样终止用CreateThread()创建的线程<<--参与者人人有分
- 如果我用msflexgrid绑定data控件,那么当用户点击msflexgrid的某一行的时候,data控件是否会自动定位在对应的这个记录呢?
- 如何动态新增、移除 ODBC DSN?
- [100分求]如何用鼠标拖动IMAGE控件平滑移动?
- 如何取得commdialog.showopen的文件路径?
- 各位瞧瞧这个软件,请提宝贵意见
- 怎样在菜单前面加图标?
- 请问DataGrid怎样绑定一个ADO数据集?
- 我用vb的webBrowser控件,为何有时出现链接不能用
- ado的问题
wfx_wzhzc表是在那创建的? 给出的代码里只有goConnect.Execute "drop table wfx_wzhzc"一句有这个表名,存储过程里创建的临时表名是wfx_bzhzc
http://www.china-askpro.com/msg21/qa32.shtml