f_find_storageid.srf 531 B

12345678910111213141516171819202122232425
  1. $PBExportHeader$f_find_storageid.srf
  2. global type f_find_storageid from function_object
  3. end type
  4. forward prototypes
  5. global function string f_find_storageid (string arg_storageid)
  6. end prototypes
  7. global function string f_find_storageid (string arg_storageid);Long ins_storageid
  8. String rslt_storagename = ''
  9. ins_storageid = Long(arg_storageid)
  10. SELECT storagename
  11. INTO :rslt_storagename
  12. FROM u_storage
  13. Where storageid = :ins_storageid;
  14. IF sqlca.SQLCode <> 0 THEN
  15. RETURN ''
  16. ELSE
  17. RETURN rslt_storagename
  18. END IF
  19. end function