>>>>>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?
Works ok for me...anyway try "SELECT myview" instead of " USE myview" after you create it. Your settings may be locking the file somehow.