ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: omerix on November 10, 2017, 01:00:07 pm

Title: New Record
Post by: omerix on November 10, 2017, 01:00:07 pm

I'm entering a new record. ID and other columns are turning empty.

New Record Video:
https://www.youtube.com/watch?v=DexaoYyHuAk

Title: Re: New Record
Post by: paramvir on November 10, 2017, 09:52:27 pm

It says "Video is unavailable".

Title: Re: New Record
Post by: omerix on November 10, 2017, 11:22:57 pm

Hello,

I gave everyone access.

https://youtu.be/DexaoYyHuAk

Title: Re: New Record
Post by: paramvir on November 10, 2017, 11:32:26 pm

addList sent back by server is supposed to contain same values as the posted addList with the exception of record Id.

Title: Re: New Record
Post by: omerix on November 11, 2017, 01:40:11 am

Quote from: paramquery on November 10, 2017, 11:32:26 pm

addList sent back by server is supposed to contain same values as the posted addList with the exception of record Id.

It worked like this.

But I want to show the values recorded in other columns. For this add  "grid.refreshDataAndView ();" after the line "grid.commit ({type: 'add', rows: changes.addList} I added the line.

There seems to be no other way.

Title: Re: New Record
Post by: omerix on November 11, 2017, 04:18:39 am

I think I solved it.  ;D

I do not know if there is a shorter way.
rd['ID']=response.addList[index].ID;

Code: [Select]

success: function (response) {
/*
$.each(response.updateList,function(index, value){
console.log('update'+index);
$.each(value,function(index, value) {
console.log(index+'/'+value);
});
});
*/
var ri; //rowIndex
var rd; //rowData
var postChanges = grid.getChanges();

$.each(postChanges.addList,function(index, value){
ri=value.pq_ri;
console.log('ADD/rowIndex='+ri+',Changes Tinyint='+value.TINYINT+',Response Tinyint='+response.addList[index].TINYINT);
grid.addClass({rowIndx: ri, cls: 'pq-striped-error'});
rd = grid.getRowData({rowIndx: ri});
rd['ID']=response.addList[index].ID;
rd['TINYINT'] = response.addList[index].TINYINT;
grid.refreshRow({rowIndx:ri});
})


$.each(postChanges.updateList,function(index, value){
ri=value.pq_ri;
console.log('UPDATE/rowIndex='+ri+',Changes Tinyint='+value.TINYINT+',Response Tinyint='+response.updateList[index].TINYINT);
grid.addClass({rowIndx: ri, cls: 'pq-striped-error'});
rd = grid.getRowData({rowIndx: ri});
rd['TINYINT'] = response.updateList[index].TINYINT;
grid.refreshRow({rowIndx:ri});
})

grid.commit({ type: 'add', rows: response.addList });
grid.commit({ type: 'update', rows: response.updateList });
grid.commit({ type: 'delete', rows: response.deleteList });
grid.history({ method: 'reset' });
},


Quote from: paramquery on November 10, 2017, 11:32:26 pm

addList sent back by server is supposed to contain same values as the posted addList with the exception of record Id.