Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> simple trigger problem ?

simple trigger problem ?

From: norab <norab_at_digibel.org>
Date: 2000/05/08
Message-ID: <CYzR4.170401$uF1.376960@afrodite.telenet-ops.be>#1/1

as a project i developed a simple database with oracle designer, including application forms.
Here is what the problem is:

a table customer is linked to a table adress with a many to one relationship.
when i update a customer's home adress via the form, the adress of other customers who live at the same adress is also changed. off course because if 3 customers live at the same adress, only one adress record will be in the adress table. and if one of those three customers change adresses, and i update that record, the two other customers will also have that changed adress.

I was looking for a solution with database triggers (after update on adressen), but the problem is that at that point i dont know WHICH customer changed adress.

Is there a solution with database triggers or any other? tnx for al help Received on Mon May 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US