f_get_storage_mtrlprp.srf 802 B

12345678910111213141516171819202122232425262728293031323334
  1. $PBExportHeader$f_get_storage_mtrlprp.srf
  2. global type f_get_storage_mtrlprp from function_object
  3. end type
  4. forward prototypes
  5. global function long wf_get_storage_mtrlprp (long arg_storageid)
  6. global function long f_get_storage_mtrlprp (long arg_storageid)
  7. end prototypes
  8. global function long wf_get_storage_mtrlprp (long arg_storageid);long ll_rst_mtrlprp
  9. select mtrlprp into :ll_rst_mtrlprp
  10. from u_storage
  11. where storageid = :arg_storageid;
  12. if sqlca.sqlcode <> 0 then
  13. ll_rst_mtrlprp = -1
  14. end if
  15. return ll_rst_mtrlprp
  16. end function
  17. global function long f_get_storage_mtrlprp (long arg_storageid);Long ll_rst_mtrlprp
  18. SELECT mtrlprp INTO :ll_rst_mtrlprp
  19. FROM u_storage
  20. Where storageid = :arg_storageid;
  21. IF sqlca.SQLCode <> 0 THEN
  22. ll_rst_mtrlprp = -1
  23. END IF
  24. RETURN ll_rst_mtrlprp
  25. end function