Hey,
I got an ListActivity which gets its Data from a SQLite database. The
Database has 3 tables:
db.execSQL("CREATE TABLE " + TABLE_MAGAZINE + " (magazineId INTEGER
PRIMARY KEY, " +
"magazineName TEXT);");
/** Tabelle "Edition" erstellen **/
db.execSQL("CREATE TABLE " + TABLE_EDITION + " ( editionId
INTEGER PRIMARY KEY, " +
"editionName TEXT, " +
"editionContent TEXT, " +
"magazine_id INTEGER NOT NULL, " +
"FOREIGN KEY (magazine_id) REFERENCES " +
TABLE_MAGAZINE + "(magazineId));");
/** Tabelle "Article" erstellen **/
db.execSQL("CREATE TABLE " + TABLE_ARTICLE + " ( articleId
INTEGER PRIMARY KEY, " +
"articleName TEXT, " +
"articleContent TEXT, " +
"edition_id INTEGER NOT NULL, " +
"FOREIGN KEY (edition_id) REFERENCES " +
TABLE_EDITION + "(editionId));");
For the foreign Keys there are 2 Trigger:
db.execSQL("CREATE TRIGGER fki_edition_magazine_id " +
" BEFORE INSERT ON "+ TABLE_EDITION +
" FOR EACH ROW BEGIN"+
" SELECT CASE WHEN ((SELECT magazineId FROM "+
TABLE_MAGAZINE +"
WHERE magazineId = new.magazine_id ) IS NULL)"+
" THEN RAISE (ABORT,'Foreign Key Violation')
END;"+
" END;");
db.execSQL("CREATE TRIGGER fki_article_edition_id " +
" BEFORE INSERT "+
" ON "+ TABLE_ARTICLE +
" FOR EACH ROW BEGIN"+
" SELECT CASE WHEN ((SELECT editionId FROM "+
TABLE_EDITION +"
WHERE editionId = new.edition_id ) IS NULL)"+
" THEN RAISE (ABORT,'Foreign Key Violation')
END;"+
" END;");
Now I want to get the magazineName and the editionName and show them
in the ListView.
Cursor getAllMagazines() {
SQLiteDatabase db=this.getWritableDatabase();
Cursor cur= db.rawQuery("SELECT * FROM edition, magazine WHERE
edition.magazine_id = magazine.magazineId", new String [] {});
return cur;
}
At the Moment I got 1 database-entry in every table in my DB. The
Cursor also got an Count by 1.
So i create a SimpleCursorAdapter to show the content in the ListView.
/** Adapter erstellen**/
SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,
android.R.layout.simple_list_item_2, c,
new String[] {"editionName", "magazineName"},
new int[] {android.R.id.text1, android.R.id.text2});
/** Adapter setzen**/
this.setListAdapter(adapter);
this.setListAdapter(adapter);
The count of the cursor is 1, and the column names are editionName and
magazineName (LogCat). But it wont show any data.
If i use an extra attribute id INTEGER PRIMARY KEY AUTO_INCREMENT and
i only want Data from 1 Tabel, everything works fine.
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
