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

2007-11-12 Thread Trevor Talbot
On 11/12/07, Andreas <[EMAIL PROTECTED]> wrote: > Am 12.11.2007 um 14:40 schrieb Igor Tandetnik: > > I wonder - do you have any plans to eventually drop some of these > > views? Or are you just going to keep creating them, exploding the > > size of the database schema? In fact, why on earth do

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

2007-11-12 Thread Andreas
Am 12.11.2007 um 14:40 schrieb Igor Tandetnik: There is no syntax in SQLite to create a view (or anything else) with name generated at runtime from field values. A view name is a plain identifier hardcoded into the statement - it is not evaluated as an expression. great, thx for this

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

2007-11-12 Thread Igor Tandetnik
Andreas wrote: 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 insert into the config-table. The View's name shall be the content of the inserted shortName-field.