if (mycount=0) then
insert into taxDoc (taxdoc,employeeRecordID,employeeNumber,year,irxrecordid,status)
values (P_taxdoc,P_employeeRecordid,P_employeeNumber,P_year,datetimer*10+P_employeeNumber,'');
if (P_taxDoc='IR56E')
then
insert into ir56e(recordid) values (datetimer);
elseif then
else
end if;
end if;
IF (NEW.STATUS='A') THEN
END IF;
沒有留言:
張貼留言