Oracle Forms: Auto-Complete Checkbox

 In this section, I'd want to provide a sample using an autocomplete combo box that's available in Oracle Forms.

The approach generates a "list block" on a layered canvas that is dynamically filtered based on the key input in the combo box. This block displays the results of the dynamic filtering. When searching for an accurate explanation of this component's purpose, it is common to come across the designation "Combo Box Including Filter." The 'list block' is enlarged and dynamically updated with each key press while the combo box is activated; here are some examples:

• The object group OG CBOX is integrated from the cbox.olb into the corresponding form via the use of drag-and-drop and copy-and-paste:

• The Combo Box Item has been put on the C-Canvas that was inherited, and any necessary adjustments should be made.
• In the canvas that is being utilised, the position of the "List-Block" has to be altered such that.

• The Autocomplete Combo Box is activated by the WHEN-NEW-FORM-INSTANCE Trigger, which consists of the following:

*****************************************
pkg_CBOX.populate_auto_cbox(
 'CBOX', 
 'select name, name
    from europecities 
    order by 1',
 'C.DUMMY');
*****************************************

The item C.DUMMY that was obtained should be switched out for the true NEXT-ITEM that is in the combo box.

The following are some of the phases at which the answer may be put to the test:

• To Download the Full Bundle, Please Click Here.
• Scott / Tiger: SQL> @ cr_eurocities.sql
• Carry out and check the functionality of the chk lboxproto2 form.
• generate a new form following step 1): assume control of the OG _CBOX
• the new form will be executed and tested.

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.