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
