Re: [sqlite] create the trigger to delete the data from other database

[Kees Nuyt]

On Wed, 22 Apr 2009 10:33:18 -0700 (PDT), Joanne Pham
 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

Re: [sqlite] create the trigger to delete the data from other database

[Igor Tandetnik]

Joanne Pham  wrote:
> Can we have the trigger to delete to data from different database?

No.

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] create the trigger to delete the data from other database

[Joanne Pham]

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



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users