"Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > > Out of curiosity though, is there a reason why ... a view > [across multiple attached databases] can't be stored permanently?
When you open a database and first try to use it, SQLite scans the SQLITE_MASTER table and parses the schema. Views are stored in sqlite_master like all other parts of the schema. IIRC, the parser would get upset if it tried to parse a view that referenced a table that did not yet exist. For that reason, a view cannot reference a table in a different database. I might have fixed the parser at some point so that it will accept a view definition that includes undefined tables, but the restriction on views not referencing tables in other databases seems a reasonable restriction so I left that in. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
