我把adobc 的记录源属性设置为:
8 adcommandunknow
命令文本设置为:
select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and borrowmessege.passname='"& passname &"'其中最后的那个passname 是公共模块里面定义的全局变量,
问题:查询的时候没有显示出任何数据.我把passname ,改成 '200013' , 就可以查询出数据.
为什么公共模块里面定义的东西,在 命令文本里无效,
还有我该怎么办?
8 adcommandunknow
命令文本设置为:
select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and borrowmessege.passname='"& passname &"'其中最后的那个passname 是公共模块里面定义的全局变量,
问题:查询的时候没有显示出任何数据.我把passname ,改成 '200013' , 就可以查询出数据.
为什么公共模块里面定义的东西,在 命令文本里无效,
还有我该怎么办?
你需要后期设置
adodc1.commandtext="select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and borrowmessege.passname='"& passname &"'"
Adodc1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Mode=Read;Extended Properties=" & "DSN=zjnulibrary;Description=图书馆数据;APP=Visual Basic;WSID=ZJNUV;DATABASE=zjnulibrary;Trusted_Connection=Yes" & ";Initial Catalog=zjnulibrary" Adodc1.CommandType = adCmdUnknown Adodc1.RecordSource = "select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and borrowmessege.passname='" & passname & "'"end sub
我改成这样都有问题. 还是没有查询出说要的记录
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Adodc1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Mode=Read;Extended Properties=" & "DSN=zjnulibrary;Description=图书馆数据;APP=Visual Basic;WSID=ZJNUV;DATABASE=zjnulibrary;Trusted_Connection=Yes" & ";Initial Catalog=zjnulibrary"
这没有什么可改得了!
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Adodc1.CommandType = adCmdUnknown Adodc1.RecordSource = "select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
borrowmessege.passname='" & passname & "'"
改:borrowmessege.passname='" & trim(passname) & "'" '你要去除两边的空格
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''end sub
我改成这样都有问题. 还是没有查询出说要的记录
sql="select book.Bname,borrowmessege.borrowtime from Book,Borrowmessege where Book.bookid=borrowmessege.bookid and borrowmessege.passname=" & passname
Adodc1.RecordSource = sql