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 = yyyy". Now, I wish to write to both the attached database, and in-memory database when recordid is between 3000-4000. Is there a way to do this without executing the update statement twice, once for foo, and also for db2.foo (which means conditional logic, testing for recordid range)? Thanks in advance. _______________________________________________ sqlite-users mailing list email@example.com http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users