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



1 comment:

  1. Could you please explain use case where this would be required?

    ReplyDelete