Re: [sqlite] a TRIGGER to create a VIEW ? (newbie)

--- Andreas <[EMAIL PROTECTED]> wrote: > I'm trying to let a Trigger create a View. ... > Is this doable at all and maybe quoting/escaping is the problem ? Or > is it a goofy concept ? It's goofy alright, but possible: $ ./sqlite3 junk.db SQLite version 3.5.2 Enter ".help" for instructions sql

[sqlite] a TRIGGER to create a VIEW ? (newbie)

Hi sqlite-users, i'm working on a web-based workflow involving POW and Server-Side-JS and sqlite for sure. I'm trying to let a Trigger create a View. The first Trigger ('resetSyncMarker') cares for unique-keying in the config-table. The second Trigger('makeView') shall create a View on inser