On Sat, Mar 15, 2008 at 10:39:44PM +0100, Fabiano Sidler scratched on the wall: > Hi folks!
> create view dbapp as > SELECTing from dbapp is not the problem, I get the desired output. What > doesn't work is INSERTing into dbapp! I'd like to add fields via http://www.sqlite.org/lang_createview.html "You cannot COPY, DELETE, INSERT or UPDATE a view. Views are read-only in SQLite. However, in many cases you can use a TRIGGER on the view to accomplish the same thing." -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
