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. :)
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
