此语句生成sql语法错误。当它运行。我看不到问题。

sql = " update querys.dbf set query=""" & Query & """,totals=""" & totals & """,flags=""" & flags & """,connection=""" & ConnectionName & """ where queryname=""" & QueryName & """"

这是整个代码块

Dim ocmd As System.Data.OleDb.OleDbCommand
Dim sql As String

If isnew Then
    sql = " insert into querys.dbf (queryname,query,totals,flags,connection) values(""" & QueryName & """,""" & Query & """,""" & totals & """,""" & flags & """,""" & ConnectionName & """)"
    ocmd = New System.Data.OleDb.OleDbCommand(sql,Connect())
    ocmd.ExecuteNonQuery()
    ocmd.Dispose()
    Exit Sub

End If
sql = " update querys.dbf set query=""" & Query & """,connection=""" & ConnectionName & """ where queryname=""" & QueryName & """"
ocmd = New System.Data.OleDb.OleDbCommand(sql,Connect())
ocmd.ExecuteNonQuery()
ocmd.Dispose()