title: operator/operand type mismatch when update dbf file
body: <p>i have a program needs to update data in dbf file. but it keeps appear error 'operator/operand type mismatch'. here is sample code :</p>
  
  <pre><code>    Dim con As OleDbConnection = New OleDbConnection("Provider=vfpoledb;Data Source=C:\folder\paytran.dbf;Collating Sequence=machine;")
      Try
  
  
          Dim strSQL As String = "UPDATE paytran.dbf SET workhr = 20  WHERE empno = 102"
          Dim cmd As OleDbCommand = New OleDbCommand(strSQL, con)
          con.Open()
          Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
          Dim myDataSet As DataSet = New DataSet()
          ' Using DataAdapter object fill data from database into DataSet object
          myDA.Fill(myDataSet, "MyTable")
          ' Binding DataSet to DataGridView
          DGV.DataSource = myDataSet.Tables("MyTable").DefaultView
          con.Close()
          con = Nothing
      Catch ex As Exception
          MessageBox.Show(ex.Message, "Error Select Data")
  
      Finally
          If con IsNot Nothing Then
              con.Close()
          End If
      End Try
  </code></pre>
  
  <p>please help me.. </p>