how to update the column in table based on the value selected in apex4.1 [message #555553] |
Fri, 25 May 2012 01:33 ![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 the following tables,
leave_type table,it has the following fields,
1.emp_name,
2.sick
3.casual
and it has the values like following,
emp_name sick casual
guru 10 10
mishra 10 10
and leave_master table,it has the following fields,
1.emp_name,
2.leave_type
3.no_of_days
I have the form based on the "leave_master" table,
here the leave_type has the LOV which includes,
sick and casual,
when the form is filled and clicked the submit button,
i need to update the leave_type column in leave_type table,
for example,
if
emp_name:guru
leave_type:sick
no_of_days:3
then I want to update the leave_type column as,
sick=sick - no_of_days for the name 'guru'
i.e, sick=10-3=7
then the table leave_type should be,
emp_name sick casual
guru 7 10
mishra 10 10
can anyone tel me what code or method I can use?
Thank you.
|
|
|
|
|
|
|