android.database.sqlite.SQLiteException: no such table
테이블 생성이 안되어 있음
sqlite java.lang.reflect.InvocationTargetException
안되서 딴대 참고함 ...
참고 : http://here4you.tistory.com/50
//
android.database.sqlite.SQLiteException: near "IF": syntax error (code 1): , while compiling:
CREATE TABLE T_CHAT IF NOT EXISTS (CHAT_NO INTEGER PRIMARY KEY AUTOINCREMENT, BOARD_NO INTEGER CHAT_CONTENT TEXT , INST_DE TEXT , INST_USER_PK TEXT)
원인
CREATE TABLE T_CHAT IF NOT EXISTS
변경
CREATE TABLE IF NOT EXISTS T_CHAT
//
table T_CHAT has 4 columns but 5 values were supplied
4열이 있지만 5개의 값을 넣음 ...
android.database.StaleDataException: Attempting to access a closed CursorWindow.Most probable cause: cursor is deactivated prior to calling this method.
java.lang.IllegalStateException: Couldn't read row 0, col 4 from CursorWindow.
//
adb devices
adb -s 775d4c77 shell
//
why dead ...
public void drop(){
String sql = "DROP TABLE IF NOT EXISTS T_CHAT";
db.execSQL(sql);
}
android.database.sqlite.SQLiteException: near "NOT": syntax error (code 1): , while compiling: DROP TABLE IF NOT EXISTS T_CHAT