>>>>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... my code is...
CREATE SQL VIEW myview AS SELECT etc...
I use the VIEW, then I re-create it again with a different
WHERE CLAUSE. I just can not get rid of the first VIEW I
create. Can you help?