xbasic Validation was failing when run on the appserver. The message was
"Error in Xbasic script for field validation on 'PROJ_EVENT_IS_DONE'. Error reported was: command: if e.data.er_milestone_code = "RegOK" then Property not found
e.data.er_milestone_code subelement not found."
I don't have time to go through all the deails but here's the gist of it .. I have validation code on a check box "PROJ_EVENT_IS_DONE" which is checking the value of several fields before deciding if the user should be allowed to save the record.
Going through debug using working preview usually would spot the culprit in a few minutes but working preview worked flawlessly and raised no exceptions.
The data in the e.data variables was exactly as planned and I couldn't figure out why the appserver had an issue with this code . Since working preview didn't help, i changed many things and promoted to the app server ... tick tick .. many hours later ...
It turns out that the appserver can't find the value of a field if the field is a text box and the "hide column" is ticked (eg. er_milestone_code ). In this case I don't want this field to be seen so I changed its field type from "text box" to "hidden". The appserver could now find the value without issue.
So its a probably a bug because I should be able to access the value of any field on the grid regardless of how its setup.
Hope this makes sense ...
"Error in Xbasic script for field validation on 'PROJ_EVENT_IS_DONE'. Error reported was: command: if e.data.er_milestone_code = "RegOK" then Property not found
e.data.er_milestone_code subelement not found."
I don't have time to go through all the deails but here's the gist of it .. I have validation code on a check box "PROJ_EVENT_IS_DONE" which is checking the value of several fields before deciding if the user should be allowed to save the record.
Going through debug using working preview usually would spot the culprit in a few minutes but working preview worked flawlessly and raised no exceptions.
The data in the e.data variables was exactly as planned and I couldn't figure out why the appserver had an issue with this code . Since working preview didn't help, i changed many things and promoted to the app server ... tick tick .. many hours later ...
It turns out that the appserver can't find the value of a field if the field is a text box and the "hide column" is ticked (eg. er_milestone_code ). In this case I don't want this field to be seen so I changed its field type from "text box" to "hidden". The appserver could now find the value without issue.
So its a probably a bug because I should be able to access the value of any field on the grid regardless of how its setup.
Hope this makes sense ...