[android help] Before inserting a record in the database to validate that there is

Tell me more ×

Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

	Before inserting a record in the database to validate that there is, for example I have a table that has two fields, table fields VA with Customer, First, I want to validate the field if there is no customer registration and if there insert That i want to do in android using Sqlite asked Dec 21 '12 at 22:48

	String sql = "SELECT * FROM TABLE WHERE id = '" + id + "'"; Cursor data = database.rawQuery(sql, null); After this check by following code if (cursor.moveToFirst()) { // record exists } else { // record not found } answered Dec 21 '12 at 22:57

	Look at SQLite constraints. This really isn't Android-specific; it's a feature of SQLite. answered Dec 21 '12 at 23:02

	Try this, it works for me. String[] args = { myDataToCheck }; c = ourDatabase.query(DATABASE_TABLE, columns, myColumnToCheck + "=?", args, null, null, null); if (c.getCount() == 0) { // doesn't exists }else{ //exists } answered Dec 21 '12 at 23:08

	You have 2 possibilities : 1)make a select to check if there is the same key in database, then insert or update. 2)make directly an update. update will return the number of row updated, if the number is 0, so you can do an insert. answered Dec 21 '12 at 22:59

lang-sql

.

stackoverflow.comm