Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to recalculate dynamically an item when another item is modified

Christian Pitet 22 days ago — edited 2 days ago

Hi,

Under Oracle APEX 24.2.11, I try to modifiy dynamically an item P46_ID_PARTICIPATION2 when another item P46_CREE_PAR type LOV is modified.

P46_ID_PARTICIPATION2 is calculated from the value of P46_CREE_PAR with a DA who affect the value of P46_ID_PARTICIPATION2 like this :

select ID FROM AD_NOTATION WHERE BENEVOLE = :P46_CREE_PAR; 

Event type is modification of P46_CREE_PAR. But it does not work, P46_ID_PARTICIPATION2 remains on his older value.

Best regards.

Comments
Post Details
Added 2 days ago
6 comments
76 views