1. #1
    Sencha User
    Join Date
    Nov 2012
    Posts
    20
    Vote Rating
    1
    Manoj Solanki is on a distinguished road

      0  

    Default 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


  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    St. Louis, MO
    Posts
    33,714
    Vote Rating
    438
    mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of mitchellsimoens has much to be proud of

      0  

    Default


    Is this a Sencha Touch question?
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    http://www.JSONPLint.com - Source to lint your JSONP!

    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/

    Need more help with your app? Hire Sencha Services services@sencha.com

    Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is almost in print!

    When posting code, please use BBCode's CODE tags.

  3. #3
    Sencha User
    Join Date
    Nov 2012
    Posts
    20
    Vote Rating
    1
    Manoj Solanki is on a distinguished road

      0  

    Default


    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."