sql - show data in my android app(saving works just fine now) -

hey, can save data in db, doesn't show in database activity itself.

@override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); oncreatedbanddbtabled(); //db und tables erstellen wenn noch nicht vorhanden setcontentview(r.layout.main); }

private void oncreatedbanddbtabled() {     mydb = this.openorcreatedatabase(my_db_name, context.mode_private, null);     mydb.execsql("create table if not exists " + my_db_table                 + " ( id integer primary key autoincrement,"+                        "name varchar(100),"+                        "comment varchar(128),"+                        "bookingdetails varchar(255),"+                        "customerproject integer(3),"+                        "editable varchar(15))"                 +";");      }   public boolean oncreateoptionsmenu(menu menu) {       super.oncreateoptionsmenu(menu);          menu.add(0, menu_projects, 0, r.string.menuprojects)         .setshortcut('1', 'f')         .seticon(r.drawable.icon);          return true;        }  public boolean onoptionsitemselected(menuitem item){       switch (item.getitemid()) {       case menu_projects:         intent iprojects = new intent(this, projects.class);         startactivity(iprojects);         return true;       }       return false;     } 

}

this insert statement

{

                        contentvalues cv = new contentvalues();                          cv.put ( "name", name.gettext().tostring() );                          cv.put ( "comment", comment.gettext().tostring() );                          cv.put ( "bookingdetails", bookingdetails.gettext().tostring() );                          cv.put ( "project_kind", );                          cv.put ( "editable", editable.gettext().tostring() );                          mydb.insert ( projectshome.my_db_table , null, cv);                      }                     finish();                     return true; manifest: 

</manifest>  

here logcat-output moment hit save-button:

02-09 11:41:53.850: error/database(719): error inserting bookingdetails=bookingdetails project_kind=0 name=name editable=editable comment=comment 02-09 11:41:53.850: error/database(719): android.database.sqlite.sqliteexception: table projects has no column named project_kind: , while compiling: insert projects(bookingdetails, project_kind, name, editable, comment) values(?, ?, ?, ?, ?); 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqliteprogram.native_compile(native method) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqliteprogram.compile(sqliteprogram.java:110) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqliteprogram.<init>(sqliteprogram.java:59) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqlitestatement.<init>(sqlitestatement.java:41) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqlitedatabase.compilestatement(sqlitedatabase.java:925) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqlitedatabase.insertwithonconflict(sqlitedatabase.java:1300) 02-09 11:41:53.850: error/database(719):     @ android.database.sqlite.sqlitedatabase.insert(sqlitedatabase.java:1173) 02-09 11:41:53.850: error/database(719):     @ versuch.datenbank.projects_new.onoptionsitemselected(projects_new.java:132) 02-09 11:41:53.850: error/database(719):     @ android.app.activity.onmenuitemselected(activity.java:2085) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.policy.impl.phonewindow.onmenuitemselected(phonewindow.java:820) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.view.menu.menuitemimpl.invoke(menuitemimpl.java:139) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.view.menu.menubuilder.performitemaction(menubuilder.java:813) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.view.menu.iconmenuview.invokeitem(iconmenuview.java:519) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.view.menu.iconmenuitemview.performclick(iconmenuitemview.java:122) 02-09 11:41:53.850: error/database(719):     @ android.view.view.ontouchevent(view.java:3828) 02-09 11:41:53.850: error/database(719):     @ android.widget.textview.ontouchevent(textview.java:6291) 02-09 11:41:53.850: error/database(719):     @ android.view.view.dispatchtouchevent(view.java:3368) 02-09 11:41:53.850: error/database(719):     @ android.view.viewgroup.dispatchtouchevent(viewgroup.java:863) 02-09 11:41:53.850: error/database(719):     @ android.view.viewgroup.dispatchtouchevent(viewgroup.java:863) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.policy.impl.phonewindow$decorview.dispatchtouchevent(phonewindow.java:1691) 02-09 11:41:53.850: error/database(719):     @ android.view.viewroot.handlemessage(viewroot.java:1525) 02-09 11:41:53.850: error/database(719):     @ android.os.handler.dispatchmessage(handler.java:99) 02-09 11:41:53.850: error/database(719):     @ android.os.looper.loop(looper.java:123) 02-09 11:41:53.850: error/database(719):     @ android.app.activitythread.main(activitythread.java:3948) 02-09 11:41:53.850: error/database(719):     @ java.lang.reflect.method.invokenative(native method) 02-09 11:41:53.850: error/database(719):     @ java.lang.reflect.method.invoke(method.java:521) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:782) 02-09 11:41:53.850: error/database(719):     @ com.android.internal.os.zygoteinit.main(zygoteinit.java:540) 02-09 11:41:53.850: error/database(719):     @ dalvik.system.nativestart.main(native method) 

hope can me again :)

please provide more information. in error log. error might in statement itself.add details logcat first.it clarify.