请问vb在MSFLexGrid中添加数据,为什么显示至少一个参数没有被指定

来源:百度知道 编辑:UC知道 时间:2024/06/21 12:04:14
我的程序是这样的
Private Sub addbookstyle_Click()
Dim rs As New ADODB.Recordset
Dim sql As String
Dim sql2 As String
Dim str As String
str = addbookTypeNO.Text
sql = "select * from bookType"
sql2 = "select booktypeno from bookType where bootypeno='" & str & "'"
If Trim(addbookTypeNO.Text) = "" Or Trim(addbookTypeName.Text) = "" Or Trim(permitdays.Text) = "" Or Trim(bookTypeOther.Text) = "" Then
MsgBox "录入信息不能为空!", vbOKOnly
Else
Set rs = TransactSQL(sql2)
If rs.EOF = False Then
MsgBox "该类别已经存在!", vbOKOnly
Else
Set rs = TransactSQL(sql)
rs.AddNew
rs.Fields(0) = Trim(addbookTypeNO.Text)
rs.Fields(1) = Trim(addbookTypeName.Text)
rs.Fields(2) = Trim(permitdays.Text)
rs.Fields(3) = Trim(bookTypeOther.Text)
rs.Update
MsgBox "书籍类型添加成功!", vbOKOnly
Call

出错是哪一句?好像RS不能重复使用吧.你的SET方法我试过.我当初就是这样.如果你想用RS做判断.你不如重新定义多一个RS2来做判断,再与RS比较,不是更好吗?让程序清楚一些.