I am discovering an odd problem with views since upgrading to 8.0.2
If I change a view design in databases created with previous verions (R6, 7 or 8.0/8.0.1), the original column order is being retained rather than the changes I make
e.g. If I have a view with 5 columns and I rearrange them, then the original column order is being retained.
This even happens if I delete all the columns from the view and recreate new columns! The column definition is completely ignored and the original columns reappear. If I add more columns than originally existed, then the extra columns appear blank.
The column titles and formatting do chnage as expected, but the data displayed is not.
The only way to fix this is to create a new view from scratch, which is not a very suitable solution.
Has anybody else witnessed this?