안드로이드 개발 질문/답변
(글 수 45,052)
Error inserting ---
android.database.sqlite.SQLiteException: table book_info has no column named group_grade: , while compiling : INSERT INTO book_info(group_grade, brithday, phone_number, memo, email, name) VALUES(?, ?, ?, ?, ?, ?)
이런류의 구문이 오류로 뜨는데요 간단하게 전화번호부를 만들려고 디비를 작성하다가 오류가 떳네요;;;
--------------------------------------------------------------------------------------------------------------------------------------------------------------
<----테이블 구조
private static final String DATABASE_CREATE_BOOK = "create table "+" "+ DATABASE_BOOK_TABLE
+"("
+ KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT" +","
+ KEY_NUMBER + " TEXT NOT NULL" + "," + KEY_NAME + " TEXT NOT NULL" + ","
+ KEY_GROUP + "TEXT" + "," + KEY_EMAIL + " TEXT" + ","
+ KEY_URI + " TEXT" + "," + KEY_BIRTHDAY + " TEXT"+ ","
+ KEY_CALL_COUNT + " TEXT" + "," + KEY_MEMO + " TEXT" + ");";
--------------------------------------------------------------------------------------------------------------------------------------------------------------
<---
public Long createPhoneInfo(String number, String name, String group_grade, String email, String memo, String birthday) {
ContentValues Values = new ContentValues();
Values.put(KEY_NUMBER, number);
Values.put(KEY_NAME, name);
Values.put(KEY_GROUP, group_grade);
Values.put(KEY_EMAIL, email);
Values.put(KEY_MEMO, memo);
Values.put(KEY_BIRTHDAY, birthday);
return pDb.insert(DATABASE_BOOK_TABLE, null, Values);
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------
이러한 구문으로 되어 있는데 오류가 어디서 나는질 모르겟어요..
고수님들 한수부탁.
android.database.sqlite.SQLiteException: table book_info has no column named group_grade: , while compiling : INSERT INTO book_info(group_grade, brithday, phone_number, memo, email, name) VALUES(?, ?, ?, ?, ?, ?)
이런류의 구문이 오류로 뜨는데요 간단하게 전화번호부를 만들려고 디비를 작성하다가 오류가 떳네요;;;
--------------------------------------------------------------------------------------------------------------------------------------------------------------
<----테이블 구조
private static final String DATABASE_CREATE_BOOK = "create table "+" "+ DATABASE_BOOK_TABLE
+"("
+ KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT" +","
+ KEY_NUMBER + " TEXT NOT NULL" + "," + KEY_NAME + " TEXT NOT NULL" + ","
+ KEY_GROUP + "TEXT" + "," + KEY_EMAIL + " TEXT" + ","
+ KEY_URI + " TEXT" + "," + KEY_BIRTHDAY + " TEXT"+ ","
+ KEY_CALL_COUNT + " TEXT" + "," + KEY_MEMO + " TEXT" + ");";
--------------------------------------------------------------------------------------------------------------------------------------------------------------
<---
public Long createPhoneInfo(String number, String name, String group_grade, String email, String memo, String birthday) {
ContentValues Values = new ContentValues();
Values.put(KEY_NUMBER, number);
Values.put(KEY_NAME, name);
Values.put(KEY_GROUP, group_grade);
Values.put(KEY_EMAIL, email);
Values.put(KEY_MEMO, memo);
Values.put(KEY_BIRTHDAY, birthday);
return pDb.insert(DATABASE_BOOK_TABLE, null, Values);
}
--------------------------------------------------------------------------------------------------------------------------------------------------------------
이러한 구문으로 되어 있는데 오류가 어디서 나는질 모르겟어요..
고수님들 한수부탁.
나중에 group_grade를 추가 시키면서 테이블을 갱신 안해줬다던가... 이럴 가능성이 잴 큰거 같군요.