f_setprofilestring.srf 900 B

123456789101112131415161718192021222324252627282930313233343536
  1. $PBExportHeader$f_setprofilestring.srf
  2. global type f_setprofilestring from function_object
  3. end type
  4. forward prototypes
  5. global subroutine f_setprofilestring (long arg_empid, string arg_dwname, string arg_itemname, string arg_itemvalue)
  6. end prototypes
  7. global subroutine f_setprofilestring (long arg_empid, string arg_dwname, string arg_itemname, string arg_itemvalue);//UPDATE sys_user_filestring
  8. // SET itemvalue = :arg_itemvalue
  9. // WHERE empid = :arg_empid
  10. // AND dwname = :arg_dwname
  11. // AND itemname = :arg_itemname;
  12. //IF sqlca.SQLCode = 0 THEN
  13. // IF sqlca.SQLNRows = 0 THEN
  14. // INSERT INTO sys_user_filestring
  15. // (empid,
  16. // dwname,
  17. // itemname,
  18. // itemvalue)
  19. // VALUES
  20. // (:arg_empid,
  21. // :arg_dwname,
  22. // :arg_itemname,
  23. // :arg_itemvalue);
  24. // END IF
  25. //END IF
  26. //
  27. //COMMIT;
  28. //
  29. //RETURN
  30. SetProFileString(sys_fx_positon, arg_dwname, arg_itemname, arg_itemvalue)
  31. end subroutine