Do you need to use the content provider? Can't you access a database
directly, or do you need to share the data?





On 22 Juli, 15:42, mahantesh Hunagund <mahantesh.t...@gmail.com>
wrote:
> Hi ,
>
> I wanted to remove duplicates from the database. In my db duplication
> can be defined by combination of multiple columns.
> For example :
>
> _id      kind      type   Pid    name
> 1         1           1        3       aaa
> 2         1           2        3       aaa
> 3         1           1        3       aaa
> 4         2           1        3       aaa
> 5         4            1        4      bbb
>
> Here : combination of tuple <kind and type> make the uniqueness.
>  For sample query : get the row for the pid =3 , query should return rows:
> 1,2,4
>
> I can to use "distinct" clause in my sql query.  Can anyone tell me how to
> specify distict clause in query  provided by android content provider? I
> didn't understand "selection" and "selectionArgs"
> field for android query exposed by content provider.
>
> If I opt for writting rawQuery how to specify projection and URI ?
>
> Thanks,
> Mahantesh
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to