Hello! On Friday 27 February 2009 21:50:30 Kees Nuyt wrote: > A view or trigger in one database is not allowed to > reference tables (or other views) in other databases. The > reason is, the schema of the main database (in this case > your :memory: database) would be invalid once the main > database is opened without the attached database, or after > detaching it.
So I can create table to saving view definitions and create these as "temp view" to all of attached databases or disable the check of views. I think the define such as SQLITE_DISABLE_VIEW_ON_ATTACHED_DATABASE may be useful in code. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
