OPEN TESTPRO; LOOP_TESTPRO:loop fetch TESTPRO into C_PHD_TAG, C_PHD_MODE; if (NOT_FOUND=1 and tagval_not_found=1) then leave LOOP_TESTPRO; end if; begin set tagval=tagvalue(C_PHD_TAG, CPARAMETER_ID ,c_phd_mode , v_start_shift_time , v_end_shift_time); select tagval, C_PHD_TAG; IF (tagval IS NULL ) THEN SET tagval_not_found=1; END IF; set replacevalue= REPLACE(upper(formula),upper(C_PHD_TAG), tagval); select replacevalue; set tagval = null; end; end loop; close TESTPRO;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)