Hi Guys, I'm having a problem with adding a column in adding it to the table.
@Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub db.execSQL("CREATE TABLE " + DataBase_Table + " (" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Key_Name + " TEXT NOT NULL, " + Key_Age + " TEXT NOT NULL, " + Key_Location + " TEXT NOT NUll);" ); } Am i going wrong somwere in adding the Column to the table . When i run ma application , see the logcat . 09-22 16:43:09.940: INFO/Database(389): sqlite returned: error code = 1, msg = table students has no column named Location 09-22 16:43:10.030: ERROR/Database(389): Error inserting Name=sai Location=sa Age=11 09-22 16:43:10.030: ERROR/Database(389): android.database.sqlite.SQLiteException: table students has no column named Location: , while compiling: INSERT INTO students(Name, Location, Age) VALUES(?, ?, ?); 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java: 91) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java: 64) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:80) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java: 36) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java: 1145) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java: 1536) 09-22 16:43:10.030: ERROR/Database(389): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java: 1410) 09-22 16:43:10.030: ERROR/Database(389): at com.sai.saqlite.AndroidDataBase.createEntry(AndroidDataBase.java:76) 09-22 16:43:10.030: ERROR/Database(389): at com.sai.saqlite.SQLDatabaseActivity.onClick(SQLDatabaseActivity.java: 55) 09-22 16:43:10.030: ERROR/Database(389): at android.view.View.performClick(View.java:2408) 09-22 16:43:10.030: ERROR/Database(389): at android.view.View $PerformClick.run(View.java:8816) 09-22 16:43:10.030: ERROR/Database(389): at android.os.Handler.handleCallback(Handler.java:587) 09-22 16:43:10.030: ERROR/Database(389): at android.os.Handler.dispatchMessage(Handler.java:92) 09-22 16:43:10.030: ERROR/Database(389): at android.os.Looper.loop(Looper.java:123) 09-22 16:43:10.030: ERROR/Database(389): at android.app.ActivityThread.main(ActivityThread.java:4627) 09-22 16:43:10.030: ERROR/Database(389): at java.lang.reflect.Method.invokeNative(Native Method) 09-22 16:43:10.030: ERROR/Database(389): at java.lang.reflect.Method.invoke(Method.java:521) 09-22 16:43:10.030: ERROR/Database(389): at com.android.internal.os.ZygoteInit $MethodAndArgsCaller.run(ZygoteInit.java:868) 09-22 16:43:10.030: ERROR/Database(389): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) 09-22 16:43:10.030: ERROR/Database(389): at dalvik.system.NativeStart.main(Native Method) -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en