Forum /
Ext JS Community Forums 4.x /
Ext: Discussion /
Problem when delete recored from table. Sqlite Proxy(Shepsii)
Problem when delete recored from table. Sqlite Proxy(Shepsii)
I cant delete record of table having Primary Key
Model:
Ext.define('InventoryList_M', {
extend: 'Ext.data.Model',
config: {
fields: [
{name:'inventoryID',type : 'int', fieldOption : 'PRIMARY KEY ASC'},
{name:'StartTime',type:'string'},
{name:'EndTime',type:'string'},
{name:'Days',type:'string'},
{name:'ProgramName',type:'string'}
],
proxy: {
type: 'sqlitestorage',
dbConfig: {
tablename: 'tblInventoryList',
dbConn: WOTabletOrders.util.InitSQLite.getConnection()
}
}
}
});
Store:
Ext.define('InventoryList_S', {
extend: 'Ext.data.Store',
requires: ['InventoryList_M'],
config: {
model: 'WOTabletOrders.model.InventoryList_M',
autoLoad: true,
storeId: 'storeInventoryList'
}
});
Code:
var objStore=list.getStore();
var rec=objStore.getAt(index);
objStore.remove(rec);
objStore.sync();
Got an error:
undefined----could not execute statement (19 constraint failed)
Please Help Thanks in advance
Sencha - Senior Forum Manager
Is this a Sencha Touch question?
Afcourse Mitchell it is sencha touch question...
I am using Sqlite proxy for use Sqlite db in my app. And I get stuck in these problem can you help me....
InventoryId is autoincrement field and when i delete it. No reflection in db and I got console log as "Primary key must be unique 19 constraint failed."
Sencha is used by over two million developers. Join the community, wherever you’d like that community to be
or Join Us