How to Develop Query Find Form

How to Develop Query Find Form --By Lokanadham

1. Open the Template.fmb

2.  save as apps_fnd.fmb. Delete the Blockname from windows, canvases, data blocks. and also delete detail block from data block.

3. Create New Window

4. Create New Canvas

5. Assign the window name to canvas

6. Change the window name in Pre Query Trigger

7. Change the Window in App Custom package

8. Create new data block (ex: Dept)

9. Create another data block (ex:emp)

10. Change the Emp Frame Subclass information to FRAME_RECT

11. Change the dept Frame Subclass information to FRAME_RECT

12. Change the Emp Block Text  item Subclass information to TEXT

13. Change the Dept Block Text  item Subclass information to TEXT

14. Change the Window Subclass information to WINDOW

15. Change the Canvas Subclass information to CANVAS

16. Change the emp Block Subclass information to BLOCK

17. Change the Dept Subclass information to BLOCK

18. copy appstand.fmb from /u04/maxprod/apps/apps_st/appl/au/12.0.0/forms/US to local machine.

 And open the appstand.fmb 

19. Navigate to Object Groups > Query_find

20. Drag Query find to apps_find.fmb. Then You can see Query_find in Block level, Canvas Level, Object Group Level and Window Level

21. In Query_find we can see 3 buttons. New, find, clear. 

   Change the logic in New buttion(When-Button-Pressed) as below.

22. Change the logic in Find button(When-Button-Pressed) as below.

23. Create the Text Item in Query_find Canvas

24. Change Logic as below in Query_find Trigger in Dept Block

25. Change Logic as below in Pre-QueryTrigger in Dept Block

26. Navingate to form Properties and set to query find in First Navigation Data Block

27. Navingate to Query_find data Block and set to Dept in NextNavigation Data Block

28. Move the form into server and Compile the form

29. After compilation .fmb file converted into .fmx file i.e. Executable file

30. Register the Form in Apps as below below. Create Form.

31. Create Function and assign the form to function.

32. Create menu and assign funtion to menu

33. Go to Custom Application , click on your form to open. 

    Find with the Dept Number to check the Outcome.

34. Find with the Dept Number to check the Outcome.