title: SQLite Exception: near "=": syntax error (code 1): , while compiling: UPDATE person_table SET person_name=? WHERE _id =
body: <p>I am getting this exception at runtime:</p>
  
  <blockquote>
    <p>SQLite Exception: near "=": syntax error (code 1): , while compiling:
    UPDATE person_table SET person_name=? WHERE _id =</p>
  </blockquote>
  
  <p>Below I am posted the codes related to that.I am mentioned the error line 51 and 56th line in below codes.</p>
  
  <p><strong>Stacktrace:</strong></p>
  
  <pre><code>12-23 02:02:19.060: E/SQLiteLog(3011): (1) near "=": syntax error
  12-23 02:02:19.060: D/AndroidRuntime(3011): Shutting down VM
  12-23 02:02:19.060: W/dalvikvm(3011): threadid=1: thread exiting with uncaught exception (group=0xb3a8bba8)
  12-23 02:02:19.100: E/AndroidRuntime(3011): FATAL EXCEPTION: main
  12-23 02:02:19.100: E/AndroidRuntime(3011): Process: com.android.timesheet, PID: 3011
  12-23 02:02:19.100: E/AndroidRuntime(3011): android.database.sqlite.SQLiteException: near "=": syntax error (code 1): , while compiling: UPDATE person_table SET person_name=? WHERE _id =
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:58)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteStatement.&lt;init&gt;(SQLiteStatement.java:31)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteDatabase.updateWithOnConflict(SQLiteDatabase.java:1572)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.database.sqlite.SQLiteDatabase.update(SQLiteDatabase.java:1520)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at com.android.timesheet.database.PersonDatabaseHelper.updateData(PersonDatabaseHelper.java:51)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at com.android.timesheet.ModifyMember.onClick(ModifyMember.java:56)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.view.View.performClick(View.java:4438)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.view.View$PerformClick.run(View.java:18422)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.os.Handler.handleCallback(Handler.java:733)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.os.Handler.dispatchMessage(Handler.java:95)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.os.Looper.loop(Looper.java:136)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at android.app.ActivityThread.main(ActivityThread.java:5017)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at java.lang.reflect.Method.invokeNative(Native Method)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at java.lang.reflect.Method.invoke(Method.java:515)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
  12-23 02:02:19.100: E/AndroidRuntime(3011):     at dalvik.system.NativeStart.main(Native Method)
  </code></pre>
  
  <p><strong>PersonDatabaseHelper.java:</strong></p>
  
  <pre><code>public class PersonDatabaseHelper {
  
      private static final String TAG = PersonDatabaseHelper.class.getSimpleName();
  
      // database configuration
      // if you want the onUpgrade to run then change the database_version
      private static final int DATABASE_VERSION = 1;
      private static final String DATABASE_NAME = "mydatabase.db";
  
      // table configuration
      private static final String TABLE_NAME = "person_table";         // Table name
      private static final String PERSON_TABLE_COLUMN_ID = "_id";     // a column named "_id" is required for cursor
      private static final String PERSON_TABLE_COLUMN_NAME = "person_name";
      private static final String PERSON_TABLE_COLUMN_PIN = "person_pin";
  
      private DatabaseOpenHelper openHelper;
      private SQLiteDatabase database;
  
      // this is a wrapper class. that means, from outside world, anyone will communicate with PersonDatabaseHelper,
      // but under the hood actually DatabaseOpenHelper class will perform database CRUD operations 
      public PersonDatabaseHelper(Context aContext) {
  
          openHelper = new DatabaseOpenHelper(aContext);
          database = openHelper.getWritableDatabase();
      }
  
      public void insertData (String aPersonName, String aPersonPin) {
  
          // we are using ContentValues to avoid sql format errors
  
          ContentValues contentValues = new ContentValues();
  
          contentValues.put(PERSON_TABLE_COLUMN_NAME, aPersonName);
          contentValues.put(PERSON_TABLE_COLUMN_PIN, aPersonPin);
  
          database.insert(TABLE_NAME, null, contentValues);
      }
  
      public int updateData(String member_id, String memberName) {
          ContentValues cvUpdate = new ContentValues();
          cvUpdate.put(PersonDatabaseHelper.PERSON_TABLE_COLUMN_NAME, memberName);
          int i = database.update(PersonDatabaseHelper.TABLE_NAME, cvUpdate, ---&gt;51th line Error
                  PersonDatabaseHelper.PERSON_TABLE_COLUMN_ID + " = " + member_id, null);
          return i;
      } 
  
      public void deleteData(String memberID) {  
          database.delete(PersonDatabaseHelper.TABLE_NAME, PersonDatabaseHelper.PERSON_TABLE_COLUMN_ID + "="
                  + memberID, null);
      }
  
  
      public Cursor getAllData () {
  
          String buildSQL = "SELECT * FROM " + TABLE_NAME;
  
          Log.d(TAG, "getAllData SQL: " + buildSQL);
  
          return database.rawQuery(buildSQL, null);
      }
  
      // this DatabaseOpenHelper class will actually be used to perform database related operation 
  
      private class DatabaseOpenHelper extends SQLiteOpenHelper {
  
          public DatabaseOpenHelper(Context aContext) {
              super(aContext, DATABASE_NAME, null, DATABASE_VERSION);
          }
  
          @Override
          public void onCreate(SQLiteDatabase sqLiteDatabase) {
              // Create your tables here
  
              String buildSQL = "CREATE TABLE " + TABLE_NAME + "( " + PERSON_TABLE_COLUMN_ID + " INTEGER PRIMARY KEY, " +
                      PERSON_TABLE_COLUMN_NAME + " TEXT, " + PERSON_TABLE_COLUMN_PIN + " TEXT )";
  
              Log.d(TAG, "onCreate SQL: " + buildSQL);
  
              sqLiteDatabase.execSQL(buildSQL);
          }
  
          @Override
          public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) {
              // Database schema upgrade code goes here
  
              String buildSQL = "DROP TABLE IF EXISTS " + TABLE_NAME;
  
              Log.d(TAG, "onUpgrade SQL: " + buildSQL);
  
              sqLiteDatabase.execSQL(buildSQL);       // drop previous table
  
              onCreate(sqLiteDatabase);               // create the table from the beginning
          }
      }
  }
  </code></pre>
  
  <p><strong>ModifyMember.java:</strong></p>
  
  <pre><code>public class ModifyMember extends Activity implements OnClickListener {
  
      EditText et;
      Button edit_bt, delete_bt;
  
      String member_id;
  
      PersonDatabaseHelper dbcon;
  
      @Override
      protected void onCreate(Bundle savedInstanceState) {
          // TODO Auto-generated method stub
          super.onCreate(savedInstanceState);
          setContentView(R.layout.modify_member);
  
          dbcon = new PersonDatabaseHelper(getApplicationContext());  
      //  dbcon.open();    
  
          et = (EditText) findViewById(R.id.edit_mem_id);
          edit_bt = (Button) findViewById(R.id.update_bt_id);
          delete_bt = (Button) findViewById(R.id.delete_bt_id);
  
          Intent i = getIntent();
          String memberID = i.getStringExtra("memberID");
          String memberName = i.getStringExtra("memberName");
  
          member_id=memberID;  
  //      member_id = Long.parseLong(memberID);
  
          et.setText(memberName);
  
          edit_bt.setOnClickListener(this);
          delete_bt.setOnClickListener(this);
  
      }
  
      @Override
      public void onClick(View v) {
          // TODO Auto-generated method stub
          switch (v.getId()) {
          case R.id.update_bt_id:
              String memName_upd = et.getText().toString();
              dbcon.updateData(member_id, memName_upd);  ----&gt; 56th line error
              this.returnHome();
              break;
  
          case R.id.delete_bt_id:
  
              dbcon.deleteData(member_id);
              this.returnHome();
              break;
          }
      }
  
      public void returnHome() {
  
          Intent home_intent = new Intent(getApplicationContext(),
                  NewProjects.class).setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
  
          startActivity(home_intent);
      }
  
  }
  </code></pre>
  
  <p>Anybody can help me to resolve this issue.Thank you.</p>