public Cursor NameCountUpdate(){
String countNAMEs, nameCOUNT;
Cursor countID = mDB.rawQuery("select name from namecount;", null);
while (countID.moveToNext()){
countNAMEs = countID.getString(countID.getColumnIndex("name"));
Cursor cName = mDB.rawQuery("select count(*) from smscount where subject Like '%" + countNAMEs +"%';", null);
DLog.e("name : ", countNAMEs);
while (cName.moveToNext()){
nameCOUNT = cName.getString(cName.getColumnIndex("count(*)"));
mDB.rawQuery("update namecount set count = '" + nameCOUNT + "' where name = '" + countNAMEs + "';", null);
DLog.e("count : ", nameCOUNT);
}
}
return countID;
}
namecount TABLE
_id integer
name text
count text
smscount TABLE
_id integer
number text
subject text
date text
모든 컬럼은 String 으로 변환해서 집어 넣었구요
select문은 다 정상 실행 되는데 update 문이 안되네요...
어디서 틀린건지 안보이는데 알려주실 용자분 안계신가요...?ㅠㅠ