I think you're loooking in wrong place. You should check the view that gives the error.

>in my program there is a view with an alias of V_NMC. it is sometimes used and other times i used the file directly through the alias, not the most ideal situation i know but it was a project i took over and hacked a fair bit over the past few years to get it working as the customer needed. the other table, NMC2, is exactly the same and even has a view but I never use that, or at least i don't think that i do. I presume that if is USE table1 i don't use the view if there is one, and even if i did use the view i would presume that it would be unused when i issued the USE command.
>~M