iRaS wrote:
> 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 do not have rights to access that database.

-- 
Mark Murphy (a Commons Guy)
http://commonsware.com | http://twitter.com/commonsguy

Warescription: Three Android Books, Plus Updates, $35/Year

-- 
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

Reply via email to