Hello guys,
i have a problem at a POST-CHANGE trigger
for example, regarding to JUDET Text item. i have a POST-CHANGE trigger, which i wanna be fired everytime i select a different value from that LOV.
the trigger looks like:
BEGIN
SELECT id
INTO :elevi.id_judet
FROM judet
WHERE judet.denumire = :elevi.judet;
END;
so i wanna update ID_JUDET which the ID of judet each time i change the name for JUDET (from that LOV).
in my case JUDET table is
JUDET
---------
id (pk)
name
but using that trigger the problem is that the ID_JUDET field isn't updated automatically, just when i click on it, or i do something, but not everytime. what's the problem? shouldn't be updated automatically when i select the name of JUDET from a LOV ?
Best regards,