vb 访问数据库

来源：百度知道 编辑：UC知道 时间：2024/05/29 00:24:04
Dim SQLstr As String
data1.RecordsetType = 1
SQLstr = " SELECT* FROM 地址属性 WHERE"
SQLstr = SQLstr & "'" & Combo1.Text & "'" & " = "
SQLstr = SQLstr & "'" & Text12.Text & "'"
data1.RecordSource = SQLstr
data1.Refresh
以上是我进行查询数据库的代码,每次怎么老是出现FROM 语法错误呢?请高手指教

Dim SQLstr As String
data1.RecordsetType = 1
SQLstr = " SELECT* FROM 地址属性 WHERE "
SQLstr = SQLstr & Combo1.Text & " = "
SQLstr = SQLstr & "'" & Text12.Text & "'"
data1.RecordSource = SQLstr
data1.Refresh

where后面跟的应该是字段名字，而字段名字是不需要用引号括起来的，把combo1.text两侧的单引号去掉试下。

SQLstr = " SELECT* FROM 地址属性 WHERE"
WHERE后面加空格