copy value from [message #506744] |
Wed, 11 May 2011 02:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
hi,
i have used this code to get the value from a different field. it does work fine , but if i make any changes in the field from where it has to copy , the changes are not automatically effected in the other field
:APB_COMM_ACK_DATE:=:APEN_SUBMISSION_DATE;
IF :APB_COMM_ACK_DATE IS NOT NULL THEN
P_COMPARE_DATES(:APB_COMM_ACK_DATE, SYSDATE, 'GT', 'Date of Birth', 'System Date');
the above code is for the value in APEN_SUBMISSION_DATE should appear automatically appear in APB_COMM_ACK_DATE.
what is happening here is it does appear in APB_COMM_ACK_DATE when i enter the date in APEN_SUBMISSION_DATE, but later when i make changes in APEN_SUBMISSION_DATE it does not changes the APB_COMM_ACK_DATE.
what is it required to be done to clear the already populated date
|
|
|
|
|