I am updating the table values and then I want to display the updated table values in the telephone table. To do this, I use the reload () method, but when I use this method, the table is not updated (the code associated with the database does not execute), but a reboot occurs. Can someone please help me how to display updated table values using reload or not using reload.? My code
function save()
{ var v=0;
for(var n=0;n<(global.length+l);n++)
{
var x1=$('input.current')[n];
if($(x1).val()=="0")
{
var y1=$('input.new')[n];
newaloc[v]=$(y1).val();
v++;
}
}
var db = window.openDatabase("DataBase", "3.6.22", "test", 200000);
db.transaction(function(transaction)
{
transaction.executeSql('SELECT * FROM POLICIES_DET WHERE POLICY_NUMBER="'+polno+'";',[],
function(transaction, result)
{
if (result != null && result.rows != null)
{
for (var i = 0; i < result.rows.length; i++)
{
var row = result.rows.item(i);
fund=row.INSURED_AMOUNT;
}
}
},errorHandler);
},errorHandler,nullHandler);
db.transaction(insert, errorCB, successCB);
al
for(var i=0;i<global.length;i++)
{
var it=$('input.new')[i];
var k=$(it).val();
xx.push(k);
v++;
}
v=0;
db.transaction(function(transaction)
{
for(var j=0;j<xx.length;j++)
{
var c=xx[j];
var g=global[j];
if(c.length>0)
{
var vl=fund*(c/100);
transaction.executeSql('UPDATE FUND_DET SET ALLOC_PERCNT="'+c+'",FUND_VALUE="'+vl+'"WHERE POLICY_NUMBER="'+polno+'"AND FUND_DESC="'+g+'";',[],
function(transaction, result)
{
if (result != null && result.rows != null)
{
for (var i = 0; i < result.rows.length; i++)
{
var row = result.rows.item(i);
}
}
},errorHandler);
}} },errorHandler,nullHandler);
location.reload();
}
source
share