hi, for some reason i would be executing a raw query or at least a query with group by clause and having clause to the table calls from database contacts.db.
The complete query i like to execute follows: SELECT * FROM calls GROUP BY number , type , IF(duration = 0, 1, 0) HAVING MAX(date) = date ORDER BY date DESC Adding the group by clause and the having clause to the where clause will result in exception. Open the database (/data/data/ com.android.providers.contacts/databases/contacts.db) with SQLiteDatabase.openDatabase() also throws an exeception. Any ideas? -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
