title: Cannot update a numeric error, Columns of type 'NUMERIC' cannot hold value of type 'CHAR'
body: <p>so I'm trying to make a code to update a column in my table PATIENT. Unfortunately I cannot update a numeric column as I get an error saying:
  Columns of type 'NUMERIC' cannot hold value of type 'CHAR'.</p>
  
  <p>ANother error I get is that i cannot make an integer type as the WHERE clause, any thoughts?</p>
  
  <p>Heres my code</p>
  
  <pre><code>private void updateActionPerformed(java.awt.event.ActionEvent evt) {                                       
      try{
  
  
          Integer value0= Integer.parseInt(pat_id.getText());
          String value1= fName.getText();           
          String value2= lName.getText();
          Integer value3= Integer.parseInt(age.getText());
  
          String value4= (String)gender.getSelectedItem();
          String value5= address.getText();
          Integer value6= Integer.parseInt(home_number.getText());
          Integer value7= Integer.parseInt(mobile_number.getText());
          String value8= emer_cont_name.getText();
          Integer value9= Integer.parseInt(emer_cont_no.getText());
  
          String sql= "update PATIENT SET FNAME='"+value1+"', AGE='"+value3+"' WHERE PATIENT_ID='"+value0+"'";
          pst=conn.prepareStatement(sql);
  
          pst.execute();
          JOptionPane.showMessageDialog(null, "Record has been updated");
      }catch(Exception e){
          JOptionPane.showMessageDialog(null, e);
      }
      Update_table();
  }                       
  </code></pre>