This discussion is archived
2 Replies Latest reply: Mar 6, 2013 8:34 AM by FrançoisDegrelle RSS

How to control the data to display for every users?

user528488 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points