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.
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.
I understand that you want certain columns not to show at all on the canvas when a certain user opens the form. Then, in the when-new-form-instance trigger, you should set_item_property(x_item, visible, property_false) for each item you do not want to be dislayed, depending on the user.