f_get_itemcode.srf 440 B

1234567891011121314151617181920
  1. $PBExportHeader$f_get_itemcode.srf
  2. global type f_get_itemcode from function_object
  3. end type
  4. forward prototypes
  5. global function string f_get_itemcode (long arg_itemid)
  6. end prototypes
  7. global function string f_get_itemcode (long arg_itemid);String ls_itemcode
  8. //ls_itemcode = ''
  9. SELECT itemcode
  10. INTO :ls_itemcode
  11. From u_itemdef
  12. where itemid = :arg_itemid;
  13. IF sqlca.SQLCode <> 0 THEN ls_itemcode = ''
  14. RETURN ls_itemcode
  15. end function