title: Android SQLite (1) no such table: viewing error
body: <p>I know there are a few answers out for this issue but i still can't seem to get mine to work. i get error message;</p>
  
  <pre><code>04-17 11:35:35.086    2437-2437/com.chris.cv10aajproject E/SQLiteLog﹕ (1)   
  AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY
  04-17 11:35:35.090    2437-2437/com.chris.cv10aajproject E/SQLiteLog﹕ (1)
  no such table: viewing
  </code></pre>
  
  <p>my code looks like this:</p>
  
  <p>i have a <code>InsertData</code> method in my adapter that is called by my app </p>
  
  <pre><code>public long insertData(String posCode,String firstLine ,String town,String county, int roomNum,
                         int askingPrice, int currentOffer, int agreedPrice, String agentName,
                         String agentPhone,String estateAgentNam, int refurb, String Time)
  {
  
      SQLiteDatabase db = helper.getWritableDatabase();
      ContentValues contentValues = new ContentValues();
      contentValues.put(DbHelper.POST_CODE, posCode);
      contentValues.put(DbHelper.FIRST_LINE,firstLine);
      contentValues.put(DbHelper.TOWN,town);
      contentValues.put(DbHelper.COUNTY, county);
      contentValues.put(DbHelper.ROOM_NO,roomNum);
      contentValues.put(DbHelper.ASKING_PRICE,askingPrice);
      contentValues.put(DbHelper.CURRENT_OFFER, currentOffer);
      contentValues.put(DbHelper.AGREED_PRICE,agreedPrice);
      contentValues.put(DbHelper.AGENT_NAME,agentName);
      contentValues.put(DbHelper.AGENT_PHO_NUM, agentPhone);
      contentValues.put(DbHelper.ESTATE_AGENT_NAME,estateAgentNam);
      contentValues.put(DbHelper.REFURB_COST,refurb);
      contentValues.put(DbHelper.TIME_OF_APPOINTMENT,Time);
  
     long id = db.insert(DbHelper.TABLE_NAME, null, contentValues);
      return id ;
  </code></pre>
  
  <p>my on create method looks like this </p>
  
  <pre><code>  public void onCreate(SQLiteDatabase db) {
  
          try {
              db.execSQL(CREATE_TABLE);
              Message.message(context, "onCreate called");
  
          } catch (SQLException e) {
              Message.message(context, ""+e);
          }
      }
  </code></pre>
  
  <p>and the <code>CREATE_TABLE</code> is a constant that looks like this:</p>
  
  <pre><code>private static final String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + UID + "INTEGER PRIMARY KEY AUTOINCREMENT, " + POST_CODE + " VARCHAR(255)," +FIRST_LINE+" VARCHAR(255)," + TOWN + "  VARCHAR(255)  " +
              "" + COUNTY + " VARCHAR(255) ," + ROOM_NO + " INTEGER ," + ASKING_PRICE + " INTEGER , " + CURRENT_OFFER + " INTEGER , " + AGREED_PRICE + "INTEGER , " + AGENT_NAME + " VARCHAR(255)," +
              "" + AGENT_PHO_NUM + " VARCHAR(255), " + ESTATE_AGENT_NAME + " VARCHAR(255), " + REFURB_COST + " VARCHAR(255), " + TIME_OF_APPOINTMENT + " VARCHAR(255));";
  </code></pre>
  
  <p>Please any advice would be much appreciated  </p>