2

I had created two functions for insert in sqlite,

In Android 5 or greater both working fine.

And in Android 4 or down, Single Insert works fine,

But, on Bulk Insert it through an error

could not prepare statement (1 near ",": syntax error)

Single Insert

            function insert(TABLENAME, COLNAME, VALNAME, callBack) {

                var query = "INSERT INTO " + TABLENAME + "(" + COLNAME + ") VALUES (" + VALNAME + ") ";
                $ionicPlatform.ready(function () {
                    $cordovaSQLite.execute(db, query).then(function (res) {
                        console.log("INSERT " + TABLENAME + " -> " + res);
                        if (callBack)
                            callBack();
                    }, function (err) {
                        console.error(err);
                    });
                });
            }

Bulk Insert

            function bulkInsert(TABLENAME, COLNAME, VALNAMES, DATA, callBack) {

                var query = "INSERT INTO " + TABLENAME + "(" + COLNAME + ") VALUES ";
                var data = DATA;
                var rowArgs = [];
                query += VALNAMES.join(", ");
                $cordovaSQLite.execute(db, query, data).then(function (res) {
                    console.log("inserted");
                    if (callBack)
                        callBack();
                }, function (err) {
                    console.log(err);
                });

            }

Can anyone help me out, how do i fix this issue??

PS: Bulk insert parameter will be like this,

bulkInsert('users', 'id,name', ['(?,?)','(?,?)'], [[1,'abc'],[2,'xyz']], function(){});

I am asking about Cordova-SQLite not Android SQLite

Abdul Ahad
  • 246
  • 2
  • 10

0 Answers0