On Tue, 22 Feb 2005 08:58:45 -0800 (PST), Jay <[EMAIL PROTECTED]> wrote:
>
> This is probably going to be hard but you did ask...
>
> SQLite version 3.0.8
> Enter ".help" for instructions
> sqlite> create table x( a text );
> sqlite> insert into x(a) values('one');
> sqlite> create view y as select a from x;
> sqlite> select * from y;
> one
> sqlite> insert into y(a) values('two');
> SQL error: cannot modify y because it is a view
> sqlite>
>
> It would be really nice if I could join multiple tables into a view
> and insert data into the view. :)
And which table did you plan for the data to go into? What you're
asking for is data partitioning, really. That's a totally different
concept, and I suspect outside the goals of SQLite.
--
| Christopher Petrilli
| [EMAIL PROTECTED]
