Really? I never knew about that restriction before. Well, okay then. Everybody is telling me it is impossible, and that's kind of what I was thinking coming in to this so I guess that's that. Thanks!
Andrea -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Tuesday, July 08, 2008 5:08 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] View with Dynamic Fields ? Andrea Connell wrote: > > I am still holding a shred of hope for a trigger that can recreate the > view whenever the questions table is modified > I wouldn't hold much hope for that. Triggers can only execute insert, update, delete, or select SQL statements. There is no way to execute a create table or create view command. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
