2 Replies Latest reply: Mar 6, 2013 10:34 AM by François Degrelle RSS

    How to control the data to display for every users?

    user528488
      Hello Experts,

      Im creating a module in ORACLE forms6i and I want to control all the data to display for every USERs. I have 1 Table and it has 5 columns.
      My module has 5 columns and 5 rows of records to display.

      Problems:
      For USER1, I want to display all DATA in column3 and column4 only and all remaining columns shoud be null.
      For USER2 , I want to dislplay all data in Column1 only and all remaining columns should be null.

      How can i control all the data to display for each columns? Can you help me please. Im using the Clear_Items but its not working only the first row are null but the remaining
      rows has its records.

      Thanks.

      Lala