StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMy Android application is crushing if the database is not populated
text
Body
copied!<p>I got some problem with my database in my Android application. Perhaps, my application is working but let me explain you.</p> <p>Here are just parts of the code from my app.. i don't want to paste the whole it's not needed.</p> <pre><code>private SQLiteStatement insertStmt; private static final String INSERT = "insert into " + TABLE_NAME + "(name,surname) values (?,?)"; public DataHelper(Context context) { this.context = context; OpenHelper openHelper = new OpenHelper(this.context); this.db = openHelper.getWritableDatabase(); this.insertStmt = this.db.compileStatement(INSERT); } public long insert(String name, String surname) { this.insertStmt.bindString(1, name); this.insertStmt.bindString(2, surname); return this.insertStmt.executeInsert(); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, surname TEXT)"); } </code></pre> <p>So when i try to run my app i get Force close, but when i put manually :</p> <pre><code>dh.insert("test", "ooo"); </code></pre> <p>..in the onCreate method in my main activity everything is fine and working. So, the conclusion is that i must put some value for the first time i run the app so it can work properly. I thought maybe to update that row with the new informations that i insert later through some TextView's from the app but i'm wondering if there is smarter solution than this? </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