1. #1
    Sencha User
    Join Date
    Nov 2012
    Posts
    23
    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
    Gainesville, FL
    Posts
    36,604
    Vote Rating
    818
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    Is this a Sencha Touch question?
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    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 in print!

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

  3. #3
    Sencha User
    Join Date
    Nov 2012
    Posts
    23
    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."

Thread Participants: 1