سؤال عن LIST ITEM

السلام عليكم

الولا نقوم بتحويلها من text_item الى list_itemوذلك عن طريق الذهاب الى property palette

بعد ذلك تقوم نقوم بانشاء record_group من object_navegator

انقر go to navegator and then go to create

afetr that

do not touch the bottons that are found above

write the code in the text item that are found below

such as:

select s_number from supplier order by s_number; this code as an example and this code will show all the numbers for the suppliers that are found in the supplier table

*keep the name of this recourd gruop in your mind*

then create aprocedure

go to object navigator and then navigate and then create name this procedure for example ashraf

write this code in it ::::

here i have this procedure

and it's name is datial_info

write the name of the recourd group in sted of 'DTT '

and insted of i_number write the primarry key that is in your table

and go out of the plsql code

go to the object navigator under the name of the form there is atrigger

create when_new_form_instance trigger and write inside it the name of the procedure

ان شاء الله اكون وفيت في الشرح (الرجاء اذا في اخطاء سامحوني)

PROCEDURE datail_info IS

GROUP_ID RECORDGROUP :=FIND_GROUP('dtt');

LIST_ID ITEM := FIND_ITEM('i_number');

BEGIN

IF POPULATE_GROUP(GROUP_ID) <> 0 THEN

RAISE FORM_TRIGGER_FAILURE;

END IF;

CLEAR_LIST(LIST_ID);

POPULATE_LIST(LIST_ID,GROUP_ID);

END;

شكرا اخي ASHRAF