Hi All,

Current we have below tables update scenario:

There are 2 tables example1_tbl and example2_tbl. When customers update
example1_tbl, we want example2_tbl are updated automaticly. That means
example2_tbl need sync up with example1_tbl update.

For Database, how can we do this?

Thanks.

Franklin

Franklin Li wrote:
Some database systems support triggers. A trigger is a stored procedure
that will run when certain database events takes placs (mostly
modification of data). Such a procedure can be written to modify
dependent tables as you describe.

Regards,

Michael.
--
Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at http://michael.zedeler.dk/