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