Private Sub Command1_Click()
Dim strquery As String
Dim saler As String
saler = dcbsaler.BoundText
strquery = "select * from product_sale_data where product_sale_data.[saler_name]=&saler&"
Adodc3.RecordSource = strquery
Adodc3.Refresh
End Sub
此为一个查询事件,dcbsaler为一datacombo控件,从表product_sale_data的saler_name字段中与界面上dcbsaler控件的下拉表中选择的boundtext进行比较,在执行到Adodc3.Refresh时,出现一提示:
在关键字select附近有语法错误,就不能把查询与dcbsaler.boundtext相同的数据库数据显示在datagrid控件中,这个要怎么排错啊?
Dim strquery As String
Dim saler As String
saler = dcbsaler.BoundText
strquery = "select * from product_sale_data where product_sale_data.[saler_name]=&saler&"
Adodc3.RecordSource = strquery
Adodc3.Refresh
End Sub
此为一个查询事件,dcbsaler为一datacombo控件,从表product_sale_data的saler_name字段中与界面上dcbsaler控件的下拉表中选择的boundtext进行比较,在执行到Adodc3.Refresh时,出现一提示:
在关键字select附近有语法错误,就不能把查询与dcbsaler.boundtext相同的数据库数据显示在datagrid控件中,这个要怎么排错啊?
改为:
strquery = "select * from product_sale_data where saler_name='" & saler & "'"
对象‘refresh'的方法‘IADODC’失败
据查,
0x80040E14 -2147217900 The command contained one or more errors
不知道怎么解决了?各位帮帮忙,多谢了
Run-time error '-2147217900 (80040e14)'
我的Adodc1连接的是SQL Server 2000.数据库用的我自己的,这个是没有影响的。
可能是你其它有什么设置了吧或者配置有误Private Sub Command4_Click()
Dim strquery As String
Dim saler As String
saler = Me.DataCombo1.BoundText
strquery = "select * from tblWorkCenter where WCCode='" & saler & "'"
Adodc1.RecordSource = strquery
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1.Recordset
DataGrid1.Refresh
End Sub