anchor.diff:              insertPersons.setString(4, phone);
               insertPersons.setInt(5,personId);
               insertPersons.executeUpdate();
  +            
  +              // update all the user accounts with the old PersonID!
  +              String strUpdatePids = "Select person_id from users where person_id=\'" + oldPID + "\'";
  +              stmtUpPids = mCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
  +              rsetUpPids = stmtUpPids.executeQuery(strUpdatePids);
  +
  +              // Iterate through all the pids and update them.
  +              while(rsetUpPids.next()) {
  +                rsetUpPids.updateInt(1, personId);
  +                rsetUpPids.updateRow();
  +              }
               
               // update the userId only if changed, but other than userId still updates that users data.
               if(oldUser.equals(uid)) {
  
positive.code:         if(checkUserIdExists != null) {
            checkUserIdExists.close();
          }
          if(mCon != null) {
            mCon.close();
          }
  
negative.code:       PreparedStatement updateSaltsUid = null;
        PreparedStatement updatePassword = null;
        PreparedStatement updateSalt = null;
        Statement stmtUpPids = null;
        ResultSet rsetUpPids = null;
        
        // actually log in and perform statements
        try{          
  