f_get_mrate.srf 416 B

12345678910111213141516171819
  1. $PBExportHeader$f_get_mrate.srf
  2. global type f_get_mrate from function_object
  3. end type
  4. forward prototypes
  5. global function decimal f_get_mrate (long arg_moneyid)
  6. end prototypes
  7. global function decimal f_get_mrate (long arg_moneyid);decimal rslt_rate
  8. rslt_rate = 0
  9. select rate
  10. into :rslt_rate
  11. from cw_currency
  12. where moneyid = :arg_moneyid;
  13. if sqlca.sqlcode <> 0 then rslt_rate = 0
  14. return rslt_rate
  15. end function