Hi,
Under Oracle APEX 24.2.14, I have a form with a DA on modification of the element P12_PLACE, it should affect a value to the element P12_ARRIVAL_DATE (Arrival Date). When the element P12_PLACE (Place) is modified. This is the form (Arrival Date should be filled):
The dynamic action for affecting a value to Arrival Date is a select instruction:
select arrival_date
from me_volunteers
where NAME = :P12_BOOKED_FOR_VOLUNTEER
and place = :P12_PLACE;
And the elements to submit are P12_BOOKED__FOR__VOLUNTEER and P12_PLACE. But it is not affecting the value to the item P12_ARRIVAL_DATE with the result of the SQL instruction. If I run this select under SQL Commands, I get a result:
I tried to set a Static value in the DA and it works with that, I don't know why it does not work with a SQL a value from this select instruction.
Best regards.