What must you do to make this record group available to the inventories form and the other forms?

The Order Entry application contains several forms. The inventories form uses an LOV that is
based on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the
creation of the record group to the entry form of the application, which opens all the other forms,
for example, to open the inventories form, there is a When-Button Pressed trigger on the
inventories button with the following code;
OPEN _FORM (‘inventories’);
in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record
group by using the CREATE_GROUP_QUERY built in with the following arguments:
(‘warehouse_rg’ , ‘SELECT ALL WAREHOUSE.WAREHOUSE_ID,
WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?

The Order Entry application contains several forms. The inventories form uses an LOV that is
based on a record group that queries the Warehouses table to return a warehouse ID.
Several of the forms use LOVs that are based on the same query. You decide to centralize the
creation of the record group to the entry form of the application, which opens all the other forms,
for example, to open the inventories form, there is a When-Button Pressed trigger on the
inventories button with the following code;
OPEN _FORM (‘inventories’);
in a When-New-Form-instance trigger for the entry form, you create the warehouse_rg record
group by using the CREATE_GROUP_QUERY built in with the following arguments:
(‘warehouse_rg’ , ‘SELECT ALL WAREHOUSE.WAREHOUSE_ID,
WAREHOUSE.WAREHOUSE_NAME FORM WAREHOUSE order by warehouse_name);
You also populate the record group in this trigger.
What must you do to make this record group available to the inventories form and the other forms?

A.
inthe When-New-Form-instance trigger for the entry form, add a values for the SCOPE
argument of CREATE_GROUP_QUERY.

B.
inthe entry form, move the record group code to the end of the When-Button-Pressed triggers
for the buttons that open other forms, so that the record group is created and populated
immediately after OPEN_FORM is called.

C.
inthe entry form, move the record group code to the beginning of the When-Button-Pressed
triggers for the button that open other forms, so that the record group is created and populated just
before OPEN_FORM is called.

D.
inthe When-Button_Pressed triggers of the entry from the buttons that open other forms, add a
value for the SESSION argument of OPEN_FORM.

E.
inthe other forms, refer to the record group as: global.warehouse_rg.

Explanation:
Note: The CREATE_GROUP_FROM_QUERY built-in is a function and must be invoked as part of
an expression. For example:
DECLARErg_id RecordGroup;BEGIN
rg_id := CREATE_GROUP_FROM_QUERY (’employee_rg’, ‘SELECT id,first_name,last_name,sal

FROM employee’);
END;



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Padmanabhan

Padmanabhan

A is Correct Answer

nancy

nancy

A is Correct Answer