title: SQLServer Exception: Invalid column name
body: <pre><code>com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'IDPaciente'
  </code></pre>
  
  <p>I am getting this exception. This is my code:</p>
  
  <pre><code>    String query = "INSERT INTO Paciente('IDPaciente', 'NomePaciente', 'IdadePaciente', 'LocalidadePaciente') VALUES('"+IDTextField.getText()+"', '"+NomeTextField.getText()+"', '"+IdadeTextField.getText()+"', '"+LocalidadeTextField.getText()+"')";
      try
      {
          st = con.DatabaseConnection().createStatement();
          rs = st.executeQuery(query);
      }
  </code></pre>
  
  <p>I suspect the problem might be in the query itself.</p>
  
  <p>I have searched a lot and couldn't find the solution to my problem. I have tried refreshing the cache, changing permissions within the schema, restarting sql server (I am using sql server management studio 2012), I am correctly connected to my database, and nothing seems to work.</p>
  
  <p>What could I be doing wrong?
  Thank you!</p>