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