title: Update single value in SQL table in Android
body: <p>I am trying to update a value in a SQL .db file that only has 1 row in 1 table. I just want to change the CUSTOMER_ISACTIVE column though.</p>
  <pre><code>    public static final String CUSTOMER_TABLE = &quot;CUSTOMER_TABLE&quot;;
      public static final String COLUMN_CUSTOMER_EMAIL = &quot;CUSTOMER_EMAIL&quot;;
      public static final String COLUMN_CUSTOMER_PASSWORD = &quot;CUSTOMER_PASSWORD&quot;;
      public static final String COLUMN_CUSTOMRER_ISMEMBER = &quot;CUSTOMRER_ISMEMBER&quot;;
      public static final String COLUMN_CUSTOMER_ISACTIVE = &quot;CUSTOMER_ISACTIVE&quot;;
      public static final String COLUMN_CUSTOMER_PAYMENTERROR = &quot;CUSTOMER_PAYMENTERROR&quot;;
      public static final String COLUMN_CUSTOMER_AUTOCARDTOKEN = &quot;CUSTOMER_CARDTOKEN&quot;;
  
  public void upDateActiveStatus(boolean isActive){
          SQLiteDatabase db = this.getWritableDatabase();
          String SS = &quot;UPDATE &quot; + CUSTOMER_TABLE + &quot; SET &quot; + COLUMN_CUSTOMER_ISACTIVE  + &quot;=&quot; + isActive + &quot; WHERE &quot; + &quot;ID = 1&quot;;
          db.execSQL(SS);
  
  </code></pre>
  <p>But this is not working. Because when I pull the value of isActive later (I know this part works) It is unchanged.
  Any ideas?</p>
  <p>This was my error :<code> java.lang.RuntimeException: android.database.sqlite.SQLiteException: no such column: true (code 1 SQLITE_ERROR): , while compiling: UPDATE CUSTOMER_TABLE SET CUSTOMER_ISACTIVE = true</code></p>