Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language:
Expertise: Beginner
Oct 25, 2000

Trigger for Updating the Table of the Trigger

Question:
I would like it that every time I insert a row in table A, another row of the same table must be updated according to the values of the row I'm inserting. What's the best way to do this? It's impossible for me to do it with triggers—to update a row of the same table in which I define the trigger.

Answer:
Try using an intermediary table. Table A has a trigger that updates Table B. Table B has a trigger that updates Table A.

I haven't tried this, and I seem to remember somewhere that the engine will not allow such loops, but it's worth a try.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date