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 !