f_profilestring.srf 636 B

123456789101112131415161718192021222324
  1. $PBExportHeader$f_profilestring.srf
  2. global type f_profilestring from function_object
  3. end type
  4. forward prototypes
  5. global function string f_profilestring (long arg_empid, string arg_dwname, string arg_itemname, string arg_itemvalue)
  6. end prototypes
  7. global function string f_profilestring (long arg_empid, string arg_dwname, string arg_itemname, string arg_itemvalue);String ls_itemvalue
  8. SELECT itemvalue
  9. INTO :ls_itemvalue
  10. FROM sys_user_filestring
  11. WHERE empid = :arg_empid
  12. AND dwname = :arg_dwname
  13. AND itemname = :arg_itemname;
  14. IF sqlca.SQLCode <> 0 THEN
  15. ls_itemvalue = arg_itemvalue
  16. END IF
  17. RETURN ls_itemvalue
  18. end function