AddRow issue - cells getting dirty

[kshipra]

Code: [Select]

var newRow = {};
                                    var dynamicId = Math.floor(Math.random() * 10) - 100;
                                    newRow.Id = dynamicId;
                                    newRow.Deprecated = false;
                                    newRow.IsTemplate = false;
                                    newRow.Exclude = false;
                                   
                                    //newRow.pq_rowcls = 'yellow';
                                    $grid.pqGrid("addRow", { rowData: newRow, rowIndxPage: 0, checkEditable: false, history: false });
                                    $grid.pqGrid("setSelection", null);
                                    $grid.pqGrid("setSelection", { rowIndxPage: 0, dataIndx: 'EventName' });
                                    $grid.pqgrid("editFirstCellInRow", { rowIndxPage: 0 });

Id is primary key set in dataModel.

When new row is added, the cells become dirty (red sign showing in upper left corner) and get added in updatelist and addlist. On ajax success call the response has addlist with new Id but it is not getting updated.

                               grid.commit({ type: 'add', rows: jsonRsp.addList });
                                grid.commit({ type: 'update', rows: jsonRsp.updateList });
                                grid.commit({ type: 'delete', rows: jsonRsp.deleteList });

I am not sure what I am doing wrong?

[paramvir]

Primary key value of new rows should be set in remote script, not in browser side js.

[kshipra]

Hi,

The reason I was setting Id on client side was because if user clicks on AddRow multiple times to add  multiple rows , pqgrid has primary key violation error. It needs recIndx column to be unique.


This code works for adding 1 row. But if user clicks AddRow button 4 times, i get primary key violation error from pqgrid. How can i add multiple rows ?

$grid.pqGrid("addRow",
                                        {
                                            //checkEditable: false,
                                            rowList: [
                                                {
                                                    newRow: {
                                                        Deprecated: false,
                                                        IsTemplated: false,
                                                        Exclude: false,                                                       
                                                        Id: undefined
                                                    },
                                                    rowIndx: 0,
                                                    pq_rowcls: 'yellow'
                                                }
                                            ]
                                        });

[paramvir]

Please try to remove Id field from newRow as below and share a jsfiddle and version of grid if still not resolved.

Code: [Select]

newRow: {
         Deprecated: false,
         IsTemplated: false,
         Exclude: false
},


[kshipra]

Thanks, that worked.