Forum | Appery.io

I am trying to store data in my local database.
But I store data to local storage from Rest service.
I want to insert data in local database from my rest service.
How to do it to insert directly in local database.???

Hello!

Please take a look here http://docs.appery.io/tutorials/build...

I tried this url.But I can't insert in my database.
I can't understand that where to write js code Because I want to store data from rest service.
so can you explain how to do that in appery??
I share my app also with appery.The name of the app is"test".

This link should help http://docs.appery.io/tutorials/build...
Here is more information http://dev.w3.org/html5/webdatabase/
Example for saving data in localStorage prefunction populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

function errorCB(err) {
alert("Error processing SQL: "+err.code);
}

function successCB() {
alert("success!");
}

var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);/preYou can add such code on service success event.

above idea not working.
I can't insert in database.
Query not working on application

Hello!

Here is how to view localDatabase in chrome: http://docs.appery.io/tutorials/build...
Here is how to build small application to work with local Database:
1) create new application
2) place button to page
3) create event for button on "Click" event for action "Run javascript"
4) enter the following code in javascript functionprefunction populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');
tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
}

function errorCB(err) {
alert("Error processing SQL: "+err.code);
}

function successCB() {
alert("success!");
}
var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);
db.transaction(populateDB, errorCB, successCB);/pre5) test Application and make sure that local database with data appeared

Please keep in mind not every browser supports Web SQL databases.

Hello,

The tutorial links above are not working. Could you please give an updated link?

Thank you!

Hi Balázs - We've removed this tutorial, such app logic should be implemented by you now.