2 Replies Latest reply: Jan 31, 2013 11:26 AM by Andreas Weiden RSS

    40357-invalid string in example record query not issued

    967903
      hello experts,

      i am using forms 10g.in query mode i face that error 40357-invalid string in example record query not issued.
      i used these code in key-next-item trigger

      PROCEDURE KN_FOR_QUERY IS
      BEGIN
      IF :global.navigation = 'D' AND :global.mode = 'M'
      THEN

      IF NAME_IN(:SYSTEM.CURSOR_ITEM) IS NOT NULL
      THEN
      :global.temp_div_code:= :po_m.po_div_code;
      :global.temp_po_num := :po_m.po_num;
      :global.temp_po_ex_work := :PUR_DELV_D.DELV_EX_WORK;
      :global.temp_modi_num:= :po_m.po_modi_num;

      IF GET_BLOCK_PROPERTY(:SYSTEM.CURSOR_BLOCK,QUERY_HITS)=0
      THEN     
      -- message('1---'||:SYSTEM.CURSOR_BLOCK);
      -- message('2---'||:SYSTEM.CURSOR_BLOCK);
      GO_BLOCK(:SYSTEM.CURSOR_BLOCK);
      CLEAR_BLOCK(no_validate);
      EXECUTE_QUERY;
      -- ELSE
           -- NEXT_ITEM;
      END IF;
      -- ELSE
      -- mess(GET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,PROMPT_TEXT)||' Must Be Entered For Query...');
      END IF;
      ELSIF :global.navigation = 'D' and :global.mode = 'Q'
      THEN
      IF NAME_IN(:SYSTEM.CURSOR_ITEM) IS NOT NULL
      THEN
      MESS('Press Execute query button');
      go_item('tools.execute_query');
      ELSE
      mess(GET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,PROMPT_TEXT)||' Must Be Entered For Query...');
      END IF;
      ELSIF :global.navigation = 'D' and :global.mode = 'A'
      THEN
      IF NAME_IN(:SYSTEM.CURSOR_ITEM) IS NOT NULL
      THEN
      NEXT_ITEM;
      ELSE
      mess(GET_ITEM_PROPERTY(:SYSTEM.CURSOR_ITEM,PROMPT_TEXT)||' Must Be Entered...');
      END IF;
      END IF;
      END;

      Thanks
      Ravi