How to refer the tabular form field [message #556395] |
Mon, 04 June 2012 02:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d6bf1744ec18e0ca12b08316612bbc3a?s=64&d=mm&r=g) |
gurujothi
Messages: 80 Registered: January 2012 Location: Banglore
|
Member |
![gurujothi+d](/forum/theme/orafaq/images/skype.png)
|
|
Hello everyone,
I have a tabular form based on the LEAVE table,It has the following fields,
Leave_id
Employee_name
No_of_days
Status
Here Status is the updatable LOV column.
Lov includes 2 values i.e APPROVE and REJECT
and I have another Table called LEAVE_HISTORY ,It has the following fields,
Here whenever the ststus is updated in Tabular form should also be updated in LEAVE_HISTORY table status column.
I tried the following in "ON-SUBMIT AFTER COMPUTATIONS AND VALIDATIONS" process,
begin
update LEAVE_HISTORY set status= status where upper(employee_name)=upper(emp_name);
end;
but its not updating,
When we updating through forms we can use something like this,
update LEAVE_HISTORY set status= :P200_status where upper(employee_name)=upper(:P_200_emp_name); <----here we are referring page item i.e (:P_200_emp_name)
like the above code,how to refer the tabular form columns?
Thank you.
|
|
|
|
|
|