Alert if Duplicate entry is inserted in data base on unique condition javascript

Question

Am trying to create a alert condition if the duplicate value is inserted to DB on duplicate entry of data on unique state Example on my code below as test table's all columns are unique and insert query has a repeated entry of data on that i need to show sql error

Create Query

    var db = openDatabase("demo", "1.0", "demo", 200000);

            db.transaction(function(tx) {
            tx.executeSql( "CREATE TABLE IF NOT EXISTS test (Slno INTEGER PRIMARY KEY AUTOINCREMENT, column1 TEXT UNIQUE, column2 TEXT UNIQUE, column3 TEXT UNIQUE, column4 TEXT UNIQUE, column5 TEXT UNIQUE)");
        });

Insert Query

db.transaction(function(tx) {
            tx.executeSql("INSERT INTO test (column1, column2 ,column3, column4,column5) VALUES ('insert1','insert2','insert3','insert4','insert5'),('insert1','insert2','insert3','insert4','insert5');");
        });

Niki van Stein · Accepted Answer · 2015-09-24 07:06:39Z

1

You can use a error callback function that is being called when an sql error occurs.

tx.executeSql(query, values, successHandler, errorHandler);

Note that there is room for both an error and a success function.

function errorHandler(transaction, error) {
    alert("Error : " + error.message);
}

Also use a success function like this

function successHandler  (transaction, resultSet) {
            if (!resultSet.rowsAffected ) {
                // Previous insert failed. Bail.
                alert('No rows affected!');
                return false;
            }else if (resultSet.rowsAffected == 1){
                 alert("ONLY one row inserted");
            }
}

Because your insert query does not really have an error, it executes fine but does not insert both queries.

edited Sep 24, 2015 at 7:06

answered Sep 24, 2015 at 6:54

Niki van Stein

10.8k3 gold badges33 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Shaik Over a year ago

Thank s for the reply but it is not working database is opened and a table is also created but the value are not inserted can you help he hear jsfiddle.net/chsgf50t/11

Niki van Stein Over a year ago

Edited my answer. Check the success callback

Shaik Over a year ago

my question was hear if i add the errorHandler as suggested next to value query that doesn't works

tx.executeSql("INSERT INTO test (column1, column2 ,column3, column4,column5) VALUES ('insert1','insert2','insert3','insert4','insert5');",errorHandler);

Shaik Over a year ago

the place where i have placed the errorHandler is it correct i think am placing the errorHandler in a wrong place or ma be the placement code is wrong need a conformation on that

Niki van Stein Over a year ago

It is in the wrong place indeed, if you use no success you need to put null, before the errorhandler. I updated your fiddle: jsfiddle.net/chsgf50t/12 though I am not able to test it on my browser for some reason.

|

Collectives™ on Stack Overflow

Alert if Duplicate entry is inserted in data base on unique condition javascript

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related