0 Replies Latest reply: Aug 25, 2013 2:37 AM by Elad RSS

    Add record which deleted from data-block, back to the LOV

    Elad

      Hi,

      I have a LOV which consist EMPLOYEE NUMBER & EMPLOYEE NAME.

      If I inserted new record to the data-block, I what that the LOV  won't consist the employee name that I have just inserted. I mean - before I save the new record.

      This I accomplished with Francois help in his site:

       

      -- Remove the selected value from the record group
      --

      DECLARE
        rg_id RecordGroup;
        rec_count NUMBER;
      BEGIN

      -- Get the record group ID --
      rg_id := Find_Group( 'EMP_GRP' );

      -- Get the number of rows --
      rec_Count := Get_Group_Row_Count( rg_id );

        -- delete the selected row --
      FOR j IN 1..rec_Count LOOP
        If Get_Group_Number_Cell( 'EMP_GRP.EMPNO', j ) = :EMP.EMPNO Then
           Delete_Group_Row( rg_id, j );
           exit ;
        End if ;
      END LOOP;

      END;

       

      My question is about when the user in deleting an exist record from the data-block, and before he/she save this deleting - how I add back the deleting record (EMPLOYEE NUMBER & EMPLOYEE) back to the LOV?

       

      Thanks in advanced,

      Elad