asked on

oracle forms 6i tabular form

Hello Experts.
Can you please advise me on this:

I have a tabular form with the following details.when the user clicks on override[row] checkbox
sales north and sales east of the row should become nulls.

I have written the following and it works:

if name_in(:system.trigger_item) = 1 then
      :region.north:= null;
:region.east:= null;

else
      :region.north := get_item_property('region.north',database_value);
      :region.east := get_item_property('region.east',database_value);
end if;


OverrideNorth Override East
[Column] EAST

Sales Sales Override[row]
NORTH EAST
10 12 checkbox
20 14 checkbox
30 16 checkbox
40 18 checkbox
50 20 checkbox

If the user clicks on Override North then all the values in the column North should become Nulls.

Can you please advise me??

Thanks

schwertner

Use WHEN-CHECKBOX-CHANGED trigger.
Put the code in the trigger.

spsun

ASKER

Hello Schwertner,
I have put the above code in when checkbox changed in rowoverride and it works for the row.
when a user doubleclicks on North Override[when-mouse-doubleclick] I want the entire North to be null.Pl advise.does set-item-property does the trick?? I am new to oracle forms..pl advise...

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial