title: SQLite 'No such table error'
body: <p>I am trying to create tables in my <code>DBhelper</code> class and I'm continually getting this error: "No table created PAYEES".</p>
  
  <p>Because of this, the rest of the DB operations are also not working. I have put sufficient time on proof reading my <code>CreateTableQuries</code>. Here is one of my queries that fail:</p>
  
  <pre><code>private static final  String tbl3_create_string = "CREATE TABLE "+tbl3_name+" ( "+col1_tbl3_name+" INTEGER PRIMARY KEY AUTOINCREMENT, " +
              col2_tbl3_name+" TEXT, "+col3_tbl1_name+" TEXT )";
  
  public void onCreate(SQLiteDatabase db) {
  
      try {
          db.execSQL(tbl1_create_string);
          db.execSQL(tbl2_create_string);
          db.execSQL(tbl3_create_string);
          db.execSQL(tbl4_create_string);
          db.execSQL(tbl5_create_string);
          global=1;
      }
      catch (SQLException e)
      {
          Log.e("DB: OnCreate Method ", e.getMessage());
          global=0;
      }
  }
  </code></pre>
  
  <p>When I check this on SQLite's query validator it is working. </p>