cn.ConnectionString = "Provider=sqloledb;Data Source=zhangqiang;Initial Catalog=TE;User Id=sa;Password=;"
cn.Open
rs.CursorLocation = adUseClient
j = "select * from manrecord where '" & txtsql & "'"
rs.Open j, cn, adOpenDynamic, adLockBatchOptimistic
txtsql = "ygname='" & Trim$(Text1(1).Text) & "'" 请问一下,我在text1中输入111的话,为什么会出现错误.
还有j的那一条赋值语句哪里有错?
cn.Open
rs.CursorLocation = adUseClient
j = "select * from manrecord where '" & txtsql & "'"
rs.Open j, cn, adOpenDynamic, adLockBatchOptimistic
txtsql = "ygname='" & Trim$(Text1(1).Text) & "'" 请问一下,我在text1中输入111的话,为什么会出现错误.
还有j的那一条赋值语句哪里有错?
txtsql那条呢?