Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Behavior of Set_Item_Property - RECORDS_DISPLAYED

Elías FernándezApr 22 2025 — edited Apr 22 2025

Hello:

In Forms 14. I think that Set_Item_Property('BLOCK.ITEM', RECORDS_DISPLAYED) has a strange behavior:

A block configured to display 10 records, like this:

In that block I have a Item with “Number or Items Displayed” with 0, so it assumes the value of the block of 10. So far so good, it shows 10 records.

If is executed Set_Item_Property('USER_OBJECTS.STATUS', RECORDS_DISPLAYED, 1); to display only 1 record is ignored and does nothing.

In Forms Builder I change the "Number of Items Displayed" in the item to 10 and do the same test with the same result, it does nothing.

But, curiously, if the item is set to 9 in “Number of Items Displayed” in Forms Builder and the block has 10 in “Number of Records Displayed”, when is executed “Set_Item_Property('USER_OBJECTS.STATUS', RECORDS_DISPLAYED, 1)” it works well.

So for the change of the RECORDS_DISPLAYED property of Set_Item_Property to work, the item has to have a “Number of Items Displayed” different from 0 and different from the “Number of Records Displayed” in the block.

Also, another issue is that in the RECORDS_DISPLAYED help of Set_Item_Property it says “Zero. Zero indicates that the item should display the number of instances specified by the Number of Records Displayed block property. ”, but if you try to do Set_Item_Property('USER_OBJECTS.STATUS', RECORDS_DISPLAYED, 0); it returns the error “FRM-41851: RECORDS_DISPLAYED property must be between 1 and MAX_RECORDS_DISPLAYED”

Regards,

Comments
Post Details
Added on Apr 22 2025
3 comments
136 views