> Is there any workaround for this? Maybe there is a trick to define the > view in a different way in order to make clear that it relates to the > database it's located in, and not to any database whichever is "main" > currently?
Are you referencing "main" in your view explicitly? If so then don't do it. If not then show us your ask_art view please. Pavel On Wed, Oct 14, 2009 at 2:30 PM, Wolfgang Enzinger <[email protected]> wrote: > Hi, > > it looks like I cannot ATTACH a database that contains a VIEW: > > sqlite> ATTACH DATABASE 'G:\Project\ASK_ORA\ask.db' AS dbsrc; > SQL error: malformed database schema (ask_art) - view ask_art cannot > reference objects in database main > sqlite> > > Obviously SQLite tries to apply the view to tables in the "current" > database, not in the attached database. > > Is there any workaround for this? Maybe there is a trick to define the > view in a different way in order to make clear that it relates to the > database it's located in, and not to any database whichever is "main" > currently? Or maybe a way to make SQLite simply "skip" (ignore) any > view in the to-be-attached database? > > Any pointers much appreciated! > > Wolfgang > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
