oracle forms les08
TRANSCRIPT
![Page 1: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/1.jpg)
8Copyright © 2004, Oracle. All rights reserved.
Creating LOVs and Editors
![Page 2: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/2.jpg)
8-2 Copyright © 2004, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following:
• Describe LOVs and editors
• Design, create, and associate LOVs with text items in a form module
• Create editors and associate them with text items in a form module
![Page 3: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/3.jpg)
8-3 Copyright © 2004, Oracle. All rights reserved.
Overview of LOVs and Editors
Text item
Editor
Text item Text item
LOV
Supporting datarecord group
![Page 4: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/4.jpg)
8-4 Copyright © 2004, Oracle. All rights reserved.
Overview of LOVs and Editors
• LOVs– List of values for text items– Dynamic or static list– Independent of single text items– Flexible and efficient
• Editors– Override default editor– Used for special requirements such as larger
editing window, position, color, and title
![Page 5: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/5.jpg)
8-6 Copyright © 2004, Oracle. All rights reserved.
LOVs and Record Groups
Text item
LOV
Text item
LOV
Database
Record group Record groupRecord groupbased on
static data
Query-basedrecordgroup
ORSQL
![Page 6: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/6.jpg)
8-7 Copyright © 2004, Oracle. All rights reserved.
LOVs and Record Groups
EMPLOYEES table
SELECT employee_id, first_name ||
' '|| last_name NAME, phone_numberFROM employeesWHERE job_id = 'SA_REP'ORDER BY last_name
Employee_id Name
Sales Rep record group
Sales Representatives LOV
![Page 7: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/7.jpg)
8-8 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV Manually
1
2
3
4
![Page 8: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/8.jpg)
8-9 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard:SQL Query Page
Edit query if needed
![Page 9: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/9.jpg)
8-10 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard: Column Selection Page
![Page 10: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/10.jpg)
8-11 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard: Column Properties Page
![Page 11: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/11.jpg)
8-12 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard: Display Page
![Page 12: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/12.jpg)
8-13 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard: Advanced Properties Page
![Page 13: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/13.jpg)
8-14 Copyright © 2004, Oracle. All rights reserved.
Creating an LOV with the LOV Wizard: Assign to Item Page
![Page 14: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/14.jpg)
8-15 Copyright © 2004, Oracle. All rights reserved.
LOV Properties
Filter BeforeDisplay
?
(X,Y)
AutomaticSelect
AutomaticSkip
Width
Height
LOV
Column Mapping
Return Items
![Page 15: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/15.jpg)
8-16 Copyright © 2004, Oracle. All rights reserved.
Setting LOV Properties
LOV
Column Mapping
AutomaticPosition
AutomaticColumn Width
Return Items
![Page 16: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/16.jpg)
8-17 Copyright © 2004, Oracle. All rights reserved.
LOVs: Column Mapping
Employee_id
orders.sales_rep_id orders.sales_rep_name orders.salesrep_phone
Hiddencolumn
Phone number1-415-555-6281
![Page 17: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/17.jpg)
8-19 Copyright © 2004, Oracle. All rights reserved.
Defining an Editor
![Page 18: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/18.jpg)
8-20 Copyright © 2004, Oracle. All rights reserved.
Setting Editor Properties
![Page 19: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/19.jpg)
8-21 Copyright © 2004, Oracle. All rights reserved.
Associating an Editor with a Text Item
• Associate one of two types of editors with a text item.
• Set text item’s Editor property to one of the following:– Null (default Forms
Builder editor)– Editor name
(customized editor)
![Page 20: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/20.jpg)
8-22 Copyright © 2004, Oracle. All rights reserved.
Summary
In this lesson, you should have learned that:• An LOV is a scrollable pop-up window that
enables a user to pick the value of an item from a multicolumn dynamic list
• The easiest way to design, create, and associate LOVs with text items is to use the LOV Wizard
• An Editor is a separate window that enables the user to view multiple lines of a text item simultaneously, search and replace text in it, and modify the text
• You create editors in the Object Navigator and associate them with text items in the item's Property Palette
![Page 21: Oracle forms les08](https://reader034.vdocuments.us/reader034/viewer/2022042508/55c5ab89bb61eb5a1f8b4744/html5/thumbnails/21.jpg)
8-23 Copyright © 2004, Oracle. All rights reserved.
Practice 8 Overview
This practice covers the following topics:
• Creating an LOV and attaching the LOV to a text item
• Creating an Editor and attaching it to a text item