Page Comparison

Update PD Proposal Status

Code Block

language	sql
title	View proposal status values

...

select * from proposal_state;

Code Block

language	sql
title	View status of selected proposal status values

select *proposal_number, status_code from eps_proposal where proposal_statenumber='1234';

...

Code Block

language	sql
title	Update status of selected proposal

...

update eps_proposal set status_code='6' where proposal_number='1234';