how can i change the Proxy.dbConfig.dbQuery of a sqliteproxy after definition of the store or model
i want to press a button and change the criteria of the selected rows of the table, i have tried this when updating
Code:
var p = myStore.getProxy();
p.queryDB(p.dbConfig.dbConn, 'Update table set column=300;');
successfully executing the update query or select some data
Code:
function querySuccess(tx, results) {
document.getElementById('total').innerHTML=results.rows.item(0).Num+' Total';
}
var p = this.store.getProxy();
p.queryDB(p.dbConfig.dbConn, 'select count(*) as Num FROM table;',querySuccess);
but now i want to change the dbquery of the storage and i cant find how to do this
Code:
var p = this.store.getProxy();
p.dbconfig.dbQuery = 'Select * from table order by column desc Limit 30';
im just starting with sencha and js in general, thanks for your help