RE: [sqlite] Trigger on Attached Database

Try to create a TEMPorary trigger after the ATTACH command. Regards Marc >Is it possible to do this: > > Open DB1 > > Attatch DB2 > > >In DB1 have a trigger that does > > Insert into DB2. ? > >Theoretically it seems possible but we couldn't get it to work. Before I >investigate further just

AW: [sqlite] Trigger on Attached Database

Just forgot to mention: Referencing in previous open/attached databases should also be possible with foreign key constraints, when they will be enforced... Marc On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote: >> Is it possible to do this: >> >>Open DB1 >> >>Attatch DB2 >>

RE: [sqlite] Trigger on Attached Database

On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote: >> Is it possible to do this: >> >>Open DB1 >> >>Attatch DB2 >> >> In DB1 have a trigger that does >> >> Insert into DB2. ? >> >> Theoretically it seems possible but we couldn't get it to work. Before I >> investigate

[sqlite] Re: What about Foreign Key support (when?)

k support in sqlite, so our effort won't be in vain. ( I read "The Definitive Guide to SQLite" be Mike Owens [excellent], which mentions the fk support to be expected end of 2006 ) Regards Marc Ruff - To unsu

[sqlite] What about Foreign Key support (when?)

Key constraints!? Great! When? Any plans yet? Best regards Marc Ruff

AW: [sqlite] sqlite shared-cache mode usage

in advance. Marc Ruff -Ursprüngliche Nachricht- Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 27. August 2006 19:07 An: sqlite-users@sqlite.org Betreff: [sqlite] sqlite shared-cache mode usage Good morning all, I'm in the design stage of a project and had a question