performUpdate issues...

Classic Servoy
1

I have a performUpdate issue that seems to have stopped working…

On a sales order form with line items, I used the following method to fill a showFormInDialog with selected line items triggered from a onDataChange date_shipped field:

var idate_shipped = date_shipped;
var icsono = csono; //“%” + utils.stringTrim(csono) + “%”;
var iinabcalc = inabcalc;

forms.onShipStageDateChange.controller.find();
forms.onShipStageDateChange.csono = ‘%’ + icsono + ‘%’;
forms.onShipStageDateChange.inabcalc = iinabcalc;
var count = forms.onShipStageDateChange.controller.search();

if (count > 1) {
application.showFormInDialog( forms.onShipStageDateChange, -1, -1, 950, 400, ‘SO LINE ITEM SHIP DATE CHANGES’, true, false, true)
}

I set the date_shipped, csono, and inabcalc to variable because it just never worked properly without them…

On the onShipStageDateChange form I have an Execute button that allows the user to view the foundset before filling all of the found line items with the same date_shipped…

if (foundset.getSize() > 0) {

var idate_shipped = forms.production_facility_detail_tab2.foundset.date_shipped;

idate_shipped = utils.dateFormat (idate_shipped, ‘MM/dd/yyyy’);

var fsUpdater = databaseManager.getFoundSetUpdater(foundset);
fsUpdater.setColumn(‘date_shipped’, idate_shipped);
fsUpdater.performUpdate();

controller.saveData();

application.closeFormDialog(true);

} else {

return;
}
controller.saveData();

databasemanager.refreshRecordFromDatabase(foundset,-1)

I not sure if the following picture of what is happening to the fsUpdater is what is supposed to happen…

Can someone enlighten me?

2

is ‘date_shipped’ text or date? You input text…

3

Its a date field Marcel.I am giving date as an input.

4

I am giving date as an input.

No, you are not. Utils.dataFormat makes it a text with the entered format…

var idate_shipped = forms.production_facility_detail_tab2.foundset.date_shipped; 

idate_shipped = utils.dateFormat (idate_shipped, 'MM/dd/yyyy');
5

You are correct sir, and I was unclear… it was an html field and I was getting the attached error…

so I changed it to a text field…

6

I am not clear if this is solved now but this message tells you what I told you. You are setting the date field with a text (html) value…