Em 10/9/2012 02:22, mathewabraham68007 escreveu:

>
> I checked with a database manager, first the view is dropped and created again, and data is retrived. but for the second time the view cannot be dropped..
>

My first advice is to not recreate the view each time, there is no
reason to do that,


Use a SQL statament directly or create the view once and use it without
recreating.

see you !