Views displaying wrong data 1

[RiverGuy]

Hi. This has happened to me once before. I didn't worry about it at that time because I was able to get the data I needed from someplace else.

But basically here is what is going on:

I have some views. One of them retrieves data from another view. The source view runs perfect. The other view though, now displays numbers in a text column. Its showing values from another, calculated field that the view contains.

So it is basically showing the calculated field twice, and the text field no times. The column names are OK, just showing the wrong data. It happens without warning.

Any ideas would be appreiciated.

 

[cdukes]

This can often happen when the underlying view has been recompiled, but the view above as not. The view above is still expecting data that used to come out of the original view and therefore formats it accordingly.

try recompiling both views.

Hope this helps

Chris Dukes

 

[RiverGuy]

OK thanks. I will give that a try and let you know if it works out.

 

[RiverGuy]

I even ran the SQL statement out of the destination view in Query Analyzer, and it did not help matters. BTW, how do you recompile a view?

Thanks

 

[RiverGuy]

I figured recompiling meant saving it again possibly, so I tried that and it worked, thans.