On Thu, Aug 26, 2010 at 04:32:11PM +0100, Simon Slavin scratched on the wall: > > On 26 Aug 2010, at 3:36pm, Alan Chandler wrote: > > > On 26/08/10 13:38, Simon Slavin wrote: > >> > >> On 26 Aug 2010, at 12:12pm, Alan Chandler wrote: > >> > >>> This time it reported that the view it would have created failed because > >>> the table (view) already existed. > >> > >> I'm sorry to ask this, but can you check for us whether a VIEW by that > >> name really does exist ? Don't forget, VIEWs get saved in the file, > >> they're not part of the attachment. > > > > Yes it does > > So you are trying to create a VIEW which does already exist. In that > case, there's no mystery about why you're getting an error message.
No, he's trying the *PREPARE* a CREATE VIEW *statement* for a view that already exists. Prepare != execute. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
