title: SQL : Update Statement : Syntax Error
body: <p>The <code>Votes</code> column defualt value is 0. Every time when I click the button it must add whichever value I want to the specific row I want. </p>
  
  <p>My error is : </p>
  
  <blockquote>
    <p>Syntax error : Update statement. [[Delphi]]  </p>
  </blockquote>
  
  <p>This is my code :</p>
  
  <pre><code>procedure TForm4.BitBtn1Click(Sender: TObject);    
  var     
    spinval : integer;
  begin
    spinval := SpinEdit1.value;``
  
    // Candidatetable.Insert;
    // Candidatetable['Votes'] := Candidatetable['Votes'] + spinval;
  
    ADOQuery1.Active := false;
    ADOQuery1.SQL.Text := 'Update Candidate_table set votes = ''' +
                          Candidatetable['Votes'] + IntToStr(spinval) +
                          ''' where Name = ''' + DBLookupComboBox1.Text + '''';
  
    ADOQuery1.ExecSQL;
    ADOQuery1.Active := false;
    ADOQuery1.SQL.Text := 'Select * from Candidate_table';
    ADOQuery1.Active := true;
  
    MessageDlgPos('Thank you for voting. You will be logged out.' , mtInformation, [mbOK], 0, 1000, 500);
  
    Form4.Hide;
    Form2.Show;
  end;
  </code></pre>
  
  <p>PlEASE HELP =)</p>
  
  <p>Thanks.</p>