StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POproblem with multiple tables is a database
text
Body
copied!<pre><code>public class DatabaseHelper extends SQLiteOpenHelper { public static final String DATABASE_CREATE_PROGRAM = "create table " + TABLE_PROGRAM + "(" + BaseColumns._ID + " integer primary key autoincrement, " + KEY_PROGRAM_TITLE + " text, " + KEY_PROGRAM_DATE + " varchar(20), " + KEY_PROGRAM_TIME + " varchar(20), " + KEY_PROGRAM_CHANNEL + " text)"; public static final String DATABASE_CREATE_CANDIDATE = "create table " + TABLE_CANDIDATE + "(" + BaseColumns._ID + " integer primary key autoincrement, " + KEY_CANDIDATE_NAME + " text, " + KEY_CANDIDATE_AGE + " text, " + KEY_CANDIDATE_REPRE + " text, " + KEY_CANDIDATE_EDULVL + " text, " + KEY_CANDIDATE_OCCU + " text, " + KEY_CANDIDATE_MARSTAT + " text)"; @Override public void onCreate(SQLiteDatabase db){ db.execSQL(DATABASE_CREATE_CANDIDATE); db.execSQL(DATABASE_CREATE_VIDEO); db.execSQL(DATABASE_CREATE_COMMENT); db.execSQL(DATABASE_CREATE_PROGRAM); } } </code></pre> <p>the logcat gave me this error</p> <pre><code>04-28 04:39:25.191: ERROR/AndroidRuntime(279): Caused by: android.database.sqlite.SQLiteException: no such table: Candidate: , while compiling: INSERT INTO Candidate(Calon_Nama, Calon_Taraf_Pendidikan, Calon_Wakil_Negeri, Calon_Status_Perkahwinan, Calon_Umur, Calon_Pekerjaan) VALUES(?, ?, ?, ?, ?, ?); </code></pre> <p>here is the function that call to createdata.</p> <pre><code>private void createdata(){ String name[] = {"aaa","bbb"}; String age[] = {"aaa","bbb"}; String represent[] = {"aaa","bbb"}; String edulvl[] = {"aaa","bbb"}; String occupation[] = {"aaa","bbb"}; String marstat[] = {"aaa","bbb"}; for(int i = 0; i<2 ; i++){ sqlite.createCandidateData(name[i], age[i], represent[i], edulvl[i], occupation[i], marstat[i]); } } </code></pre> <p>SQLite class</p> <pre><code>public long createCandidateData(String name, String age, String represent, String edulvl, String occupation, String marstat){ ContentValues values = new ContentValues(); values.put(DatabaseHelper.KEY_CANDIDATE_NAME, name); values.put(DatabaseHelper.KEY_CANDIDATE_AGE, age); values.put(DatabaseHelper.KEY_CANDIDATE_REPRE, represent); values.put(DatabaseHelper.KEY_CANDIDATE_EDULVL, edulvl); values.put(DatabaseHelper.KEY_CANDIDATE_OCCU, occupation); values.put(DatabaseHelper.KEY_CANDIDATE_MARSTAT, marstat); return mDb.insertOrThrow(DatabaseHelper.TABLE_CANDIDATE, null, values); } </code></pre> <p>how come the Candidate second table cannot be created in same database?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload