View columns retaining previous design

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?

Subject: If this is just one db…

If this is just one db, try running an updall -R against it, to rebuild the views. This is if the problem is not workstation-specific. If it only happens at one workstation, shut down your client and do the following:

  1. delete cache.ndk

  2. Rename desktop6.ndk → desktop6.old

Restart your client.

I hope that helps!

Subject: I see the exact same thing on 8.5!!

Haven’t been able to fix it yey either!