0 Replies Latest reply: Oct 27, 2008 7:49 AM by 469057 RSS

    Strange behavior of KEY-LISTVAL trigger for date field

    469057
      The code down lead to next behaviour:
      - When I use the List of Value (LOV) fil the field up with a sysdate.
      I choose one period from the LOV, but the field becomes empty.
      -------------------------------------
      /* CGAP$OLES_SEQUENCE_BEFORE */
      declare
      l_cursor_item VARCHAR2(200) := :system.cursor_item;
      l_null_value BOOLEAN := false;
      begin
      if :system.cursor_value is null
      then
      copy(sysdate,l_cursor_item);
      l_null_value := true;
      end if;
      --
      qms$calendar.key_listval;
      --
      if l_null_value
      then
      copy(null,l_cursor_item);
      end if;
      end;
      -------------------------------------------
      It seems logical behavior of this code.
      But I don't understand why Headstart 6.5.4.0. generated this code.
      Headstart version 6.5.0 hasn't this code. There it is simply:

      /* CGAP$OLES_SEQUENCE_BEFORE */
      begin
      qms$calendar.key_listval;
      end;