SQLite can anyone assist in the insert / edit and delete statement .....

[Rudolf Britz]

SQLite insert item method. Could you please assist me in finding any and or methods to add, edit and delete data in a SQLite database. I used code on button click but it did not work see code below.

Second question: Is this possible as a data service in the same manner as the select all list in the example?

________________________________________________________

attempted code on button click - ps the alert gave the correct response

var db = window.openDatabase("Wedding 0.1", "", "Wedding 0.1", 1024*1000);

var v_Top = Appery('top');
var v_Number = Appery('number');
var v_Left = Appery('left');
var v_visible = Appery('active');

alert(v_Top.val() + '--' + v_Number.val() + '--' + v_Left.val() + '--' + v_visible.val());

db.transaction(function(tx) {
tx.executeSql('INSERT INTO QRList (number, top, left, QRList_Company) VALUES (?, ?, ?, ?)' , [v_number.val(), v_Top.val(), v_Left.val(), v_visible.val()]) ;

Code: Select all

    });

[Evgene Karachevtsev]

Hello Rudolf,

This tutorial should be helpful: http://devcenter.appery.io/tutorials/...

[Rudolf Britz]

I agree that this has the select statement but it has no Insert / Update / delete statement.

[Kateryna Grynko]

Hi Rudolf,

There is an Insert: http://devcenter.appery.io/tutorials/... (section 10).

You could see another examples:
http://www.thegeekstuff.com/2012/09/s...