Guys,
I ran into the following on 2.2 final and tested it on 2.2.1RC3 and got the same result:
1- I have a form in TableView mode
2- The Tableview is showing a couple of columns of which at least one is based on a calculation
3- I set the anchors both on left and right, so the columns are resizable and reorderable
4- In the header of the form there’s a button which calls:
databaseManager.refreshRecordFromDatabase(forms[formName].foundset,-1);
5- when I open the solution, go to this particular form the columns are still in the order as defined in Developer. In this case, when I hit the button to refresh the foundset, no problems
6- When I reorder the columns in such a way that the column based on a calculation changes position and then I hit the button to refresh the foundset, the values in the column based on the calculation disappear!!!
I’ve tested different scenario’s but it seems to me that in every case where the column based on a calculation moves to a different position than defined in Developer, a refresh of the foundset will make the values disappear.
After the refresh of the foundset, you can get the values in the calculated column back by clicking in one of the displayed records. When you click on the last record in the list, the values return for all records again.
Can this behavior be fixed?
Paul
PS: I haven’t tested it for Portals, maybe this issue is present there as well.