Re: Trgger Question

[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <19971207000600.TAA01101@ladder02.news.aol.com>, kponn@aol.com says... > Hi > > I have four tables A,B,C, and D with prod_number. I am trying to write a > trigger to delete prod-numbers from B,C, and D if I delete a prod_number from > A. Since I can only have one delete triggrer on A , I have the following: > > create trigger ....... delete on A ....... > for each row ( > delete from B; > delete from C; > delete from D;> ) > > <snip> Keith Try formatting your trigger this way create trigger ....... delete on A ....... for each row ( delete from B, delete from C, delete from D ); -- Michael J. Erickson (Michael_Erickson@iname.com) Any opinions expressed here are my own and do not necessarily reflect those of my employer or clients.