Question

no such table 오류가 나는데 .. 왜나는지 모르겠습니다.

 

오류가 난 sql문을 sqllite로 돌려보면 결과가 잘나오는데

소스에서 exec 하면 오류가납니다.

  쿼리문에는 main.speeddail이 없는데

오류문에서는 main.speeddail 테이블이 없다고 뜨네요.. 왜그럴까요 ?

Comments

12-30 22:27:53.256: E/AndroidRuntime(3067): android.database.sqlite.SQLiteException: no such table: main.speeddail (code 1): , while compiling: CREATE VIEW view_raw_entities AS SELECT contact_id, raw_contacts.deleted AS deleted,is_primary, is_super_primary, data_version, data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, line, data_sync1, data_sync2, data_sync3, data_sync4, raw_contacts.account_id,accounts.account_name AS account_name,accounts.account_type AS account_type,accounts.data_set AS data_set,(CASE WHEN accounts.data_set IS NULL THEN accounts.account_type ELSE accounts.account_type||'/'||accounts.data_set END) AS account_type_and_data_set,raw_contacts.sourceid AS sourceid,raw_contacts.name_verified AS name_verified,raw_contacts.version AS version,raw_contacts.dirty AS dirty,raw_contacts.sync1 AS sync1,raw_contacts.sync2 AS sync2,raw_contacts.sync3 AS sync3,raw_contacts.sync4 AS sync4, data_sync1, data_sync2, data_sync3, data_sync4, speeddail._id AS speed , speeddail.contacts_id, raw_contacts._id AS _id, data._id AS data_id,raw_contacts.starred AS starred,0 AS raw_contact_is_user_profile,groups.sourceid AS group_sourceid FROM raw_contacts JOIN accounts ON (raw_contacts.account_id=accounts._id) LEFT OUTER JOIN data ON (data.raw_contact_id=raw_contacts._id) LEFT OUTER JOIN speeddail ON ( data._ID= speeddail.contacts_id) LEFT OUTER JOIN packages ON (data.package_id=packages._id) LEFT OUTER JOIN mimetypes ON (data.mimetype_id=mimetypes._id) LEFT OUTER JOIN groups ON (mimetypes.mimetype='vnd.android.cursor.item/group_membership' AND groups._id=data.data1)

---

쿼리문:
CREATE VIEW view_raw_entities AS SELECT * FROM

raw_contacts JOIN accounts ON (raw_contacts.account_id=accounts._id)
 LEFT OUTER JOIN data ON (data.raw_contact_id=raw_contacts._id)
LEFT OUTER JOIN speeddail ON ( data._ID= speeddail.contacts_id)
LEFT OUTER JOIN packages ON (data.package_id=packages._id)
LEFT OUTER JOIN mimetypes ON (data.mimetype_id=mimetypes._id)
LEFT OUTER JOIN groups ON (mimetypes.mimetype='vnd.android.cursor.item/group_membership' AND groups._id=data.data1)

이렇게 보시면 더편하실듯... 쿼리문에 speeddail 테이블을 조인했는데
오류에는 main.speeddail 테이블이 없다고 나옵니다.