I have the following code ,but when the method insertLabel() is called from MainActivity ,Logcat throws an exception saying tabel labels has no column named name , eventhough i am creating the column ,please let me know if anything is missing :
Its throwing android.database.sqlite.SQLiteException : table labels has no column named nmes(code 1).Still unable to figure out why!!
Is that the exact error message, copy and pasted? Is the code you posted the exact code? Why is the column being used in the error message as nmes and not name like the constant in your code? Note that there are two differences: a missing a and an added s.
If both the code and the error message are correct, then un-install the app and try re-installing it. It could be that the application did not properly close at one point and was left in memory. You make changes but those changes may not be properly reflected in the app that runs. If you are using Eclipse to compile the code, it won't hurt to do a clean build as well - I have seen the build not finish completely but not provide errors either, allowing a bad mix of code to reach the phone which caused 'impossible' errors.