>>>>I have create a VIEW with CREATE SQL VIEW.
>>>>After using the VIEW, I return to my table.
>>>>I then create the same VIEW using the same name myview), but I am
>getting
>>the previous VIEWS results? What do I do?
>>>Are you creating the view each time with a different WHERE condition?
>
>>Yes I am. I am using a different string with the WHERE CLAUSE.
>do you remove the old view from the dbc?
>
>- remember views are not exactly like cursors
>
>Arnon
No I did not remove the old view from the dbc. How do you do that?
and... does the table have to be in exclusive.
All I want to do is re-use the same VIEW with a different WHERE CLAUSE.
can you help?