Forum | Appery.io

Hello Dave,

You can create value object:

code var value = {_id:1,
number:1,
RxName: "name",
Dose : 1,
Freq_Num : 1,
Freq_Per : 1,
RxNum : 1,
Pharmacy : "sss",
PharmNum: 1,
Notes : "sss",
StoreNum: 1,
_createdAt : "01.01.2014",
_updatedAt : "01.01.2014"
} ;/code

and delete return in file "MedDB_LocRestJS.js"

Hi Evgene,
I inserted the above and am getting some unexpected extra lines in local storage.. Please help me.

My script is now as follows:

Appery.MedDB_LocRestJS = Appery.createClass(null, {

 init : function(requestOptions) { 
     this.__requestOptions = $.extend({}, requestOptions); 
 }, 

 process : function(settings) { 
     this.settings = settings; 
     settings.beforeSend(settings); 
     if (this.__requestOptions.echo) { 
         settings.success(this.__requestOptions.echo); 
     } else { 
         console.log('Default implementation is used. Please define your own.'); 
         settings.success({}); 
     } 
     settings.complete('success'); 
 } 

});

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

var value = {_id:1,
number:1,
RxName: "name",
Dose : 1,
Freq_Num : 1,
Freq_Per : 1,
RxNum : 1,
Pharmacy : "sss",
PharmNum: 1,
Notes : "sss",
StoreNum: 1,
_createdAt : "01.01.2014",
_updatedAt : "01.01.2014"
} ;

db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS "MedsColl"(_objectId TEXT, RxName TEXT, Dose TEXT, Freq_Num TEXT, Freq_Per TEXT, RxNum TEXT, Pharmacy TEXT, PharmNum TEXT, Notes TEXT, StoreNum TEXT, _createdAt DATETIME, updatedAt DATETIME)', []);
tx.executeSql('SELECT * FROM "MedsColl" WHERE "objectId" = "' + value.id + '"', [], function(tx, results){
tx.executeSql('INSERT INTO "MedsColl" (objectId, RxName, Dose, Freq_Num, Freq_Per, RxNum, Pharmacy, PharmNum, Notes, StoreNum, _createdAt, updatedAt) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', [value.id, value.RxName, value.Dose, value.Freq_Num, value.Freq_Per, value.RxNum, value.Pharmacy, value.PharmNum, value.Notes, value.StoreNum, value.createdAt, value.updatedAt]);
}
);
});

Hello Dave!

I am sorry to have to tell you, but building app with offline DB fails outside the scope of our support. We have posted a lot of suggestions, but building app, reviewing/debugging custom app code/scripts are outside the scope of support.
You can contact Appery.io services team http://appery.io/services/ so they can take a closer look at your problem.