f_update_aps_mtrl_will.srf 660 B

1234567891011121314151617181920212223242526272829303132
  1. $PBExportHeader$f_update_aps_mtrl_will.srf
  2. global type f_update_aps_mtrl_will from function_object
  3. end type
  4. forward prototypes
  5. global function integer f_update_aps_mtrl_will (ref string arg_msg, boolean arg_if_commit)
  6. end prototypes
  7. global function integer f_update_aps_mtrl_will (ref string arg_msg, boolean arg_if_commit);Int rslt = 1
  8. DECLARE pro1 Procedure FOR dt_sys_update_aps_mtrl_will ;
  9. EXECUTE pro1;
  10. IF sqlca.SQLErrText <> '' THEN
  11. rslt = 0
  12. arg_msg = '重算物料监控表失败,' + sqlca.SQLErrText
  13. GOTO ext
  14. END IF
  15. CLOSE pro1;
  16. ext:
  17. IF rslt = 1 THEN
  18. IF arg_if_commit THEN
  19. COMMIT;
  20. END IF
  21. ELSE
  22. ROLLBACK;
  23. END IF
  24. RETURN rslt
  25. end function