Sunday, March 27, 2016

Oracle Forms tutorial in bangla How to create dynamic list



Today we will learn
How to create a dynamic list in Oracle forms 10g
okay lets log on to your form builder as usual....

Step- 1: create a new data block and takes employees table
         information to create a dynamic list.

Step- 2: Rename your block name as your sweet will for
        creating the dynamic list

Step- 3: Decorate your items in your default canvas to see
        your dynamic list properly.

Step- 4: Now select your desired item where you want to
        create dynamic list.

Step- 5: Go to the property palette of that item
                (The dynamic list    item).

step- 6: change the item type to list item.
              (where dynamic list will show).

step- 7: and be careful about the list item list,make it blank.
       (sometimes it creates default (one) list).

step- 8: Now create a new record group from the
               navigator to see the  record in dynamic list.
                which will come from a query.

step- 9: rename the record group name as your wish.

step-10: go to the record group's property palette.

step-11: write the query in the 'record group query'
                to show the dynamic list.
step-12: close the record group.

step-13: now go to the object navigator of the
                dynamic list module.

step-14: write a 'WHEN-NEW-FORM-INSTANCE' TRIGGER
                 below the module to show
           the dynamic list properly.
step-15: then close your trigger.

step-16: compile your form and than run your form.


see the dynamic list what you wanted see.


if you have learned something from this tutorial
(how to create a dynamic list)
please like my video and subscribe my channel...

Thanks for watching....

Subscribe : Mahfujur Rahman....

Subscribe my channel : Mahfujur Rahman

Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.01673472384

No comments:

Post a Comment