1 / 20

Creating LOVs and Editors

Creating LOVs and Editors. 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. LOVs and Editors.

kalei
Download Presentation

Creating LOVs and Editors

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating LOVs and Editors

  2. 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

  3. LOVs and Editors Editor Text item Text item Text item LOV Supporting data record group

  4. 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 • System editor available as an option

  5. LOVs and Record Groups Text item Text item LOV LOV Record group Record group based on static data Query-based record group Record group OR SQL Database

  6. Customers LOV name id phone city Customers record group LOVs S_CUSTOMERtable SELECT name, id, phone, city FROM s_customer ORDER BY name

  7. New LOV

  8. LOV Queries • Avoid very large queries—use restrictions. • Use column in LOV to validate user input—place this column first in SELECT list. • Define return items later, or use optional INTO clause. • Use optional WHERE, GROUP BY, and ORDER BY clauses.

  9. LOV Properties Width (X,Y) LOV Automatic Select Height Column Mapping FilterBefore Display ? Automatic Skip Return Items Automatic Display

  10. LOV Properties Automatic Column Width LOV Automatic Position Column Mapping Return Items

  11. customer.name customer.id customer.phone customer.city Phone City 809-352689 San Pedro De 1-415-555-6281 San Francisco 91-1031 New Delhi 52-404562 Nogales Customers LOV Hidden columns name id phone city Customers record group LOV Column Mapping S_CUSTOMER table SELECT name, id, phone, city FROM s_customer ORDER BY name

  12. Creating an LOV Using the LOV Wizard: SQL Query Page

  13. Creating an LOV Using the LOV Wizard: Column Selection Page

  14. Creating an LOV Using the LOV Wizard: Column Properties Page

  15. Creating an LOV Using the LOV Wizard: Display Page

  16. Creating an LOV Using the LOV Wizard: Advanced Properties Page

  17. Editors

  18. Editors • Associate one of three types of editors with a text item. • Set text item’s Editor property to one of the following: • Null (default Form Builder editor) • editor_name (customized editor) • SYSTEM_EDITOR (external editor)

  19. Summary • LOVs and editors are form objects. • LOVs and editors can be shared across text items. • There are three steps to implement an LOV. • Text items can use the default editor, a custom editor, or a system editor.

  20. Practice 7 Overview This practice covers the following topics: • Creating an LOV and attaching the LOV to a text item • Creating an editor and attaching the editor to a text item

More Related