>>> 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.
Just to let conversation continue I'll quote Alan's earlier message in this thread: ------------------ I replaced all the parameter placeholders with a quoted version of the parameter and undertook the prepare statement again. This time it reported that the view it would have created failed because the table (view) already existed. ------------------- Note that he gets error when he prepares statement, not when executes them. Pavel On Thu, Aug 26, 2010 at 11:32 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users