Hi all,

Can anyone please provide a working database content provider example with multiple tables(using SQLite) and some join query? I am still unable to run my code. Pls help!

Hi,

We this several places in our OpenIntents project: http://code.google.com/p/openintents/

You may want to have a look at the shopping list example:
http://code.google.com/p/openintents/so ... vider.java

Hope it helps.

Peli

Hello Peli,

do you have code using explicitly a JOIN-Expression
Not these (I call it:) workaround-joins, like:


Regards,
plusminus

plusminus wrote:do you have code using explicitly a JOIN-Expression
Not these (I call it:) workaround-joins, like:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using sql Syntax Highlighting

1. contains.item_id = items._id AND contains.list_id = lists._id

Parsed in 0.002 seconds, using GeSHi 1.0.8.4

Through the projection map, only one big table is returned. So this works like an inner join, even though we did not explicitly use the JOIN expression. I wonder what would they do differently or what would the advantage of using them be?

Peli

Hello Peli,

I was not criticising your sql-statement

Some weeks ago I had problems making a join, explicitly using the JOIN-keyword.
Maybe you find my error here: http://www.anddev.org/viewtopic.php?p=3710

Regards,
plusminus

plusminus wrote:Some weeks ago I had problems making a join, explicitly using the JOIN-keyword.
Maybe you find my error here: http://www.anddev.org/viewtopic.php?p=3710

I answered you there.

Peli