On Wed, 22 Apr 2009 10:33:18 -0700 (PDT), Joanne Pham
<joannekp...@yahoo.com> wrote:

>Hi All,
>Can we have the trigger to delete to data from different database?
>My application has 2 databases and when ever the application is 
>deleting the rows in one of tables in DB1 I would like to have a
>trigger to delete the rows in table in DB2.
>Is this possible?
>Thanks,
>JP

I added this question and the answer to the SQLite wiki FAQ:

http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq

Thanks drh for the text, I took it from:
[sqlite] Foreign Constraint Triggers Across Attached
Databases (2008-01-24 11:56:16 UTC).

Cheers,
-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to