On the first glance I don't see why you would get a "view definition change" error. How do you've to change data to get that error? Can you zip up tables and email to me so I can see if it's a bug or not? I don't need the whole tables if you can repro that error on a smaler part of the tables.
>
>I got the view going as a subquery but I have one small problem which I am hoping is not a bug.
>
>Basically, the problem is that when I change the underlying data to my view I get a "View definition has been change" message.
>
>Below is my view definition. The intermediate stage was necessary because it was not calculating correctly. Requerying works fine until I change the data. I can get around it by closing the view and re-opening it but it seems to me there is something fundamental wrong here.
>
>I'm a bit mystified as to how changing the data can constitute a "view definition change". Do you think it is a bug?
>
>
<snip>
--sb--