VB6.0与SQL2008实时错误424要求对象,代码如下:
Private Sub Command1_Click()
Dim sqlCon As New ADODB.Connection
sqlCon.Provider = "SQLOLEDB"
sqlCon.Open "Server=FENGHUN-PC;Database=Library;Integrated Security=SSPI;"
Dim sqlCmd As New ADODB.Command
sqlCmd.ActiveConnection = sqlCon
sqlCmd.CommandText = "select * from LendTable"
Set sqlRes = sqlCmd.Execute
Dim sqlStr As String
sqlStr = ""
If Trim(Text1.Text) <> "" Then
sqlStr = "where ReaderTable_ID=" + Trim(Text1.Text)
End If
LibADO.RecordSource = "Select * from LendTable " & sqlStr
LibADO.RefreshEnd Sub
其中LibADO.RecordSource = "Select * from LendTable " & sqlStr被指示为错误的语句
Private Sub Command1_Click()
Dim sqlCon As New ADODB.Connection
sqlCon.Provider = "SQLOLEDB"
sqlCon.Open "Server=FENGHUN-PC;Database=Library;Integrated Security=SSPI;"
Dim sqlCmd As New ADODB.Command
sqlCmd.ActiveConnection = sqlCon
sqlCmd.CommandText = "select * from LendTable"
Set sqlRes = sqlCmd.Execute
Dim sqlStr As String
sqlStr = ""
If Trim(Text1.Text) <> "" Then
sqlStr = "where ReaderTable_ID=" + Trim(Text1.Text)
End If
LibADO.RecordSource = "Select * from LendTable " & sqlStr
LibADO.RefreshEnd Sub
其中LibADO.RecordSource = "Select * from LendTable " & sqlStr被指示为错误的语句
解决方案 »
- vb调用webservice时如何把需要的参数传递和接受返回来的结果呢?
- VB 标准表达式中数据类型不匹配 对象Refresh的方法 IAdodc失败
- 谁来推荐几本API书籍
- 电子尺,套打时特别有用
- 如何取得一个文件的编码格式?是ANSI的还是utf-8的等等
- 关于汽泡式ToolTiptext的问题已困扰我好几天,请大家帮忙!!!!!!!!
- 愿出所有分求助:VB如何写拨号服务器?就是别人用MODEM拨号到服务器的MODEM,服务器的MODEM侦测会响应并连接!
- 春节快乐!代码共享:位运算的模块(LoWord、HiWord、取得RGBA分量……)
- 我是初学者,帮帮助!
- 控件可以当作参数进行传递吗
- VB6.0与SQL2008实时错误424要求对象
- 求大神帮忙
If Trim(Text1.Text) <> "" Then
sqlStr = "where ReaderTable_ID='" + Trim(Text1.Text) & "'"
End If