f_get_storage_mtrlprp.srf 799 B

123456789101112131415161718192021222324252627282930313233
  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