| How to refer the tabular form field [message #556395] |
Mon, 04 June 2012 02:11  |
 |
gurujothi
Messages: 80
Registered: January 2012
Location: Banglore
|
Member |
|
|
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
,