想在VB中创建一个存储过程,为什么总是出错?没分了.高手请看看吧,谢谢
On Error GoTo lbErr
Dim iDb As ADODB.Connection
Set iDb = New ADODB.Connection
Dim iConcStr As String
iConcStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=master;Data Source=HX"
iDb.Open iConcStr
Dim str As String
str = "IF EXISTS (SELECT name FROM sysobjects " & _
" WHERE name = 'bbb' AND type = 'P') " & _
" DROP PROCEDURE bbb " & _
" GO " & _
" create procedure bbb " & _
" as " & _
" print 'ccc' " & _
" go "
iDb.Execute str
lbErr:
MsgBox Error, vbOKOnly + vbExclamation, "错误!"
iDb.Close
问题点数：0、回复次数：5Top
1 楼ljhdi（ ）回复于 2005-01-04 11:48:03 得分 0
先把错误处理语句注销了
再一步步调试Top
2 楼wangjun110（我狂......）回复于 2005-01-04 14:25:35 得分 0
顶
Top
3 楼wangjun110（我狂......）回复于 2005-01-04 14:28:30 得分 0
不行呀Top
4 楼xzzxg（漂流）回复于 2005-01-04 15:29:48 得分 0
MsgBox Error, vbOKOnly + vbExclamation, "错误!" & Err.Description
先看看错误信息是什么！
Top
5 楼ilons（轻轻的来,静静的接分,不带走什么,只留下几十个bytes）回复于 2005-01-04 20:22:21 得分 0
不能带GO在里面,Top
