FROM 子句语法错误

Question

    Public Function Search(ByVal Table As String, ByVal Field As String, ByVal Row As Integer) As Object
        Dim temp As Object
        Dim Cmd As New OleDbCommand("Select " & Field & " from " & Table, Acc) 'Acc是已连接的数据库.
        Dim Ds As OleDbDataReader = Cmd.ExecuteReader
        temp = Ds.GetValue(0)
        For n = 0 To Row - 1
            Application.DoEvents()
            Ds.Read()
        Next
        Ds.Close()
        Return temp
    End Function
'Access数据库
该如何解决?数据库可连接.

Answer 1

你好 请检查下你的sql语句中字段名和表名是否包含了Access的一些关键字比如user\date等如果包含可以添加[]的方式 比如
select [user] from [table]

---

Wenn ich dich hab’,gibt es nichts, was unerträglich ist.坚持不懈！http://hi.baidu.com/1987raymond

Answer 2

没有关键字冲突,表名叫"user",里面有一个字段"u_name".

Answer 3

打印出来
"Select " & Field & " from " & Table

看是什么

---

【孟子E章】

Answer 4

没有关键字冲突,表名叫"user",里面有一个字段"u_name".

你好 user是关键字 也需要加[]的
Dim Cmd As New OleDbCommand("Select " & Field & " from [" & Table & "]", Acc)

---

Wenn ich dich hab’,gibt es nichts, was unerträglich ist.坚持不懈！http://hi.baidu.com/1987raymond