Search This Blog

Thursday, March 31, 2011

How to change the status in the Response Tab from R to C (Rejected/Completed)


How to change the status in the Response Tab from R to C

1. First find the mil key for the task

select * from mil;

2. Find the sta key from sta table (R=1 and C=2)

3. Update the RSC Table

update rsc set sta_key = 1 where mil_key = 1300 and rsc_data = 'FAILURE';

Thanks