데이타베이스를 생성해서 값을 가져오려고하는데. 런타임 에러가나네요..
디디엠에스에는 ..no such by columID 가 ..ㅜㅜ
-------------------------------------------------
private static final String DB_CREATE="create table "+DB_TABLE
+DB_ID +" integer primary key autoincrement not null,"
+DB_TITLE + " text,"
+DB_CONTENT + " text,"
+DB_DATE + " text,"
+DB_TIME+ " text,"
+DB_LOCATION+ " text,"
+");";
----------------------------------------------
private void load_schedule() {
Cursor cursor=null;
try{
cursor= database.query(
DB_TABLE, new String[] {DB_ID,DB_TITLE,DB_CONTENT,DB_DATE,DB_TIME,DB_LOCATION},
null, null, null, null,null);
int numRows=cursor.getCount();
Log.v("err",Integer.toString(numRows));
cursor.moveToFirst();
for(int i=0;i<numRows;++i){
cursor.moveToNext();
//list에 출력
this.mAdapter.add(cursor.getString(i));
}
}catch(SQLException e){
Log.v("err","SQLERR");
}finally{
cursor.close();
}