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,791
    Vote Rating
    833
    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

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi