CODEWITHSUNDEEP
androidjquerysqlitecordova
SNpn
SNpn

Reputation: 2207

Updating a SQL DB throws error in Phonegap Android

I'm trying to update a form I have in my android app using the following SQL call, but for some reason it keeps throwing an error.

var updateForm = "UPDATE forms SET (forms.cid, forms.barcode, forms.startTime, forms.startDate, forms.inspector, forms.model, forms.serialNo, forms.endTime, forms.address, forms.sitename, forms.unitLocation, forms.sigName) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WHERE forms.id = ?";

function updateSingleForm() {

    var barcode = $('#barcode').val();
    var sTime = $('startTime').val();
    var sDate = $('#startDate').val();
    var inspector = $('#inspector').val();
    var model = $('#model').val();
    var serialNo = $('#serialNo').val();
    var eTime = $('#finishTime').val();
    var address = $('#address').val();
    var sitename = $('#sitename').val();
    var loc = $('#location').val();
    var signame = $('#sigName').val();
    var fid = $('#form-id').val();
    var cid = $('#client-id').val();

    var query = function query(tx) {
    tx.executeSql(updateForm, [cid, barcode, sTime, sDate, inspector, model, serialNo, eTime, address, sitename, loc, signame, fid], successDBCall2, onError)
  }

    db.transaction(query, onError3);

}

function onError3() { alert('broken here'); }

The alert in onError3 seems to be called, meaning the query is broken somewhere but I can't see the problem. Can someone please help.

Upvotes: 0

Views: 112

Answers (1)

CL.
CL.

Reputation: 180080

The correct syntax for an UPDATE statement is like this:

UPDATE forms
SET cid = ?, barcode = ?, startTime = ?, startDate = ?,
    inspector = ?, model = ?, serialNo = ?, endTime = ?,
    address = ?, sitename = ?, unitLocation = ?, sigName = ?
WHERE id = ?

Upvotes: 2

Related Questions