>I have a Table ProjDetl.
>
>View1 is based on Projdetl and View2 is based on view1.
>
>Why is it that when I change the data in Projdetl, it does not reflect in view2. It only reflects after I "run" view1. Is this normal behavior, a bug, or am I missing something???

Hi Eric,

It depends how view2 is created. I mean if definition is
SELECT * FORM view1 WHERE then it should reflect the changes.

Bye
Jayesh

- Jayesh