On Sun, 3 Aug 2008 22:16:31 -0700 (PDT), you wrote:
> I have two databases, an in memory main database
> consisting of a single table, and a disk based
> database consisting of multiple tables one of which
> is also the same table as the one in memory database.
> Let's say in memory database table "foo" consists of
> records 1-4000. The "foo" table in attached database
> "db2" consists of records 3000-4000.
> All writes are updates after initializing the in-
> memory database. What I want to do is execute
> "UPDATE foo set val=xxx, where recordid = ".
> Now, I wish to write to both the attached database,
> and in-memory database when recordid is between
> Is there a way to do this without executing the
> update statement twice,
1- you can't update a join
2- you can't define a trigger over
main and attached databases
> once for foo, and also for
> db2.foo (which means conditional logic, testing for
> recordid range)?
> Thanks in advance.
( Kees Nuyt
sqlite-users mailing list