[android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Luca Carlon
This is very important for me! I didn't even see it! Thank you very very much! On Jan 3, 10:45 am, Sarwar Erfan wrote: > On Monday, January 3, 2011 3:32:50 PM UTC+6, Luca Carlon wrote: > > > Assuming I am the ContentProvider developer, can I somehow execute > > these kinds of queries (using funct

Re: [android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Kostya Vasilyev
Luca, The way a ContentProvider maps a query into SQL statements is entirely up to your provider. The framework only imposes a few things: - The "data bucket" is selected by the URI. - The query is specified as an array of values. - The result is returned as a Cursor (not necessarily a SQLite

[android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Sarwar Erfan
On Monday, January 3, 2011 3:32:50 PM UTC+6, Luca Carlon wrote: > > Assuming I am the ContentProvider developer, can I somehow execute > these kinds of queries (using functions like replace, using subqueries > etc...) using the SQLiteDatabase class? Its query method seems to > suffer the same

[android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Luca Carlon
I already rooted and executed the queries I need using sqlite3, but I need to do this programmatically. Assuming I am the ContentProvider developer, can I somehow execute these kinds of queries (using functions like replace, using subqueries etc...) using the SQLiteDatabase class? Its query method

[android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Sarwar Erfan
On Monday, January 3, 2011 2:32:29 PM UTC+6, Luca Carlon wrote: > > Ok, that was just to confirm that it is impossible to use it that way. > And what about making complex queries? The ContentProvider class > provides the query method which, however, seems to be quite a > limitation. What can I

[android-developers] Re: Creating complex queries for SQLite

2011-01-03 Thread Luca Carlon
Ok, that was just to confirm that it is impossible to use it that way. And what about making complex queries? The ContentProvider class provides the query method which, however, seems to be quite a limitation. What can I do, for instance, if I need to create queries with subqueries (or some other t

[android-developers] Re: Creating complex queries for SQLite

2011-01-02 Thread Sarwar Erfan
Your subject of the post should have been something like "Accessing databases from other packages" In normal phones, you are not allowed to do so. It prevents you to mess up with someone else's database. If you want it for personal usage, you can root your phone. Regards Sarwar Erfan -- You r

[android-developers] Re: Creating complex queries for SQLite

2011-01-02 Thread Zsolt Vasvari
No, I don't believe you will have access to directly open the database of another app. That's the reason there is a ContentProvider in the first place. On Jan 3, 7:28 am, Luca Carlon wrote: > Hi! I'm using the Android's media library intensively, and I was > asking myself whether it is possible