"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
From: <[EMAIL PROTECTED]>
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
So, is it not possible to create a view across a "main" and
an "attached" database?
If I recall, you can create a TEMP VIEW across attached databases.
Thanks for the tip. Adding TEMP is all it took to get things
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
>
> So, is it not possible to create a view across a "main" and
> an "attached" database?
>
If I recall, you can create a TEMP VIEW across attached databases.
But you can't create a persistent view because such a view would
not make sense to a
Hi All,
I have an open sqlite3 database (name = dbSerial), to which I've attached a 2nd
database (name = dbParent). Now, I'm trying to create a view by joining a view
from dbSerial with another view from dbParent. Attempting to create the view
generates the following error:
Error: view
I am attaching external database 'b' to database 'a',
ATTACH DATABASE b AS d_b;
and then trying to create a view that uses tables from the attached database,
CREATE VIEW v AS
SELECT d_b_t.col, d_a_t.col
FROM d_b.tbl AS d_b_t JOIN tbl AS d_a_t ON...
I get the following error --
view v
5 matches
Mail list logo