Re: [sqlite] Updating same tables in attached databases.

2008-08-04 Thread Kees Nuyt
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
> 3000-4000.
> 
> Is there a way to do this without executing the
> update statement twice, 

No. Because:
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
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Updating same tables in attached databases.

2008-08-03 Thread A. H. Ongun
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 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users