Re: How to synchronize two tables using update triggers?

Could you not Delete the old record from the other table, then insert a new record with the updates? This is what I would do, unless you have some delete or insert triggers that may interfere with the business rules of your DB

Yanhua Lu wrote in message <3511DBE0.DE2B2E63_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 Fri Mar 20 1998 - 00:00:00 CET