Ken:
I did some more testing. Apparently, it doesn't line the NVL function where it is.
Why??
Yossi
>Hi Yossi,
>
>>I have a program where I generate a number of views for a database named PSS. I'm having a problem with the following view when I use version #1. The table that I'm including in the view in version #1 exists and I see no problem with it.
>>
>>When I issue the following sequence of commands, I get an error
>>
>>
>>'View definition has changed'.
>>
>>
>>When I rerun the program with version #2, the problem goes away. What gives?
>>
>>
>In my experience, that message usually means that one of the fields in the view has changed its dimensions. Usually happens in an outer join situation but could be caused by your sum statement. Try preceeding your sum with something like 000000000.00 + SUM(etcetcetce)
>
>Hope this helps,
>
>Ken