Re: How to synchronize two tables using UPDATE triggers?

From: Guus van de Sande <dyntas.nospam_at_wxs.nl>
Date: 1998/03/23
Message-ID: <01bd5682$f5bbba60$361279c3@dyntaswxs.nl>#1/1

Although your problem might be solvable I would suggest to reconsider your DB-design. Such problems are usually caused by redundancy in your tables. Use normalisation techniques to solve the real problem !

regards.
Guus van de Sande

-- 
- remove NOSPAM from my e-mail adress -

Yanhua Lu <chang-lu_at_pacbell.net> schreef in artikel
<3511DD1A.DF8FA8F6_at_pacbell.net>...


> Hi there,

> 

> I ran into the problem of synchronizing two tables, say table A and

> table B using update triggers. What I hope to see is once a row in table

> A is updated, the correspdoning row in table B is updated right away to

> reflect the change, and vice versa. My first thought was to implement an

> AFTER update row trigger on both tables, but I realize afterwards that

> it will end up with recursive loop, i.e. table A trigger fires table B

> trigger which fires table A trigger again... Does anybody happens to

> know any work around with this problem, or you have better way to

> synchronize two tables without using triggers?

> 

> Thanks a lot in advance.

> 

> -- Lu  :)

> 

> 

> 

>

Received on Mon Mar 23 1998 - 00:00:00 CST