Oracle Forms Multirow block validation

Question

I have a table that looks like this:

+-------------------+---------+
|Name               |Jr       |
+-------------------+---------+
|Name1              |N        |
|Name2              |N        |
|Name3              |N        |
|Name1Jr            |Y        |
|Name2Jr            |Y        |
|Name3Jr            |Y        |
+-------------------+---------+

And here is what my multirow block looks like:

What I want is that when I insert for example Name2, it will automatically add under it the same name with Jr. on its end and the property of the Jr checkbox will be uneditable and checked if the Name has Jr. on its end like this:

I tried in WHEN-VALIDATE-ITEM of Name:

if :blk.name like '%Jr' then
    :blk.Jr := 'Y';
    set_item_property('blk.jr', enabled, PROPERTY_FALSE);
else  
    set_item_property('blk.jr', enabled, PROPERTY_TRUE);
end if;

But Jr becomes enabled if I enter another record that has no Jr in the end. I want it to be per row enable/disable

Littlefoot · Accepted Answer · 2018-06-08 05:16:55Z

1

Use SET_ITEM_INSTANCE_PROPERTY instead.

answered Jun 8, 2018 at 5:16

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Questionnaire Over a year ago

sir how about on how to insert record if the record I entered for example Name3, on the next line it will also insert Name3Jr

Littlefoot Over a year ago

You'd duplicate_record and :name := :name || 'Jr'

Collectives™ on Stack Overflow

Oracle Forms Multirow block validation

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related