>>>>>>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.
Hi Larry... it will not let me use SELECT, I have to use
USE. My code is:
CREATE SQL VIEW myview AS SELECT * FROM mytable
USE myview
Anyother suggestions?