Hi
I am trying to insert new row (update is working fine) and I’m getting following error
Error: Field idCol is required.
idCol is primary key of varchar type
The values of added row object debugged in chrome developer tools are:
mapped db fields poperties has all values set
row property state: 2
__newValues array has all values set
__oldValues array has all values undefined
This is two code versions both giving same error:
var objTable = new RemObjects.DataAbstract.DataTable("myDbTable");
objAdapter.getData(objTable, RemObjects.DataAbstract.Util.createRequestInfo(true, -1, "", []),
function() {
new RemObjects.DataAbstract.Views.HtmlTableView(objTable, "myHtmlTable");
objTable.appendRow();
objTable.rows[objTable.rows.length - 1].idCol = "123-ABC12";
objTable.rows[objTable.rows.length - 1].dateCol1 = "2017-03-17 16:16:16";
objTable.rows[objTable.rows.length - 1].boolCol = true;
objTable.rows[objTable.rows.length - 1].dateCol2 = "2017-03-17 15:15:15";
objAdapter.applyUpdates(objTable, function(result) {
alert("Ok");
},
function(msg, e) {
if (e) {alert(e)}
else (alert(msg.getErrorMessage()))
});
},
RemObjects.UTIL.showError
);
OR
var objTable = new RemObjects.DataAbstract.DataTable("myDbTable");
objAdapter.getData(objTable, RemObjects.DataAbstract.Util.createRequestInfo(true, -1, "", []),
function() {
new RemObjects.DataAbstract.Views.HtmlTableView(objTable, "myHtmlTable");
objTable.onNewRecord = function(row){
row["idCol"] = "123-ABC12";
row["dateCol1"] = "2017-03-17 15:15:15";
row["boolCol"] = true;
row["dateCol2"] = "2017-03-17 16:16:16";
}
objTable.appendRow();
objAdapter.applyUpdates(objTable, function(result) {
alert("Ok");
},
function(msg, e) {
if (e) {alert(e)}
else (alert(msg.getErrorMessage()))
});
},
RemObjects.UTIL.showError
);