1 / 34

Working with Data Blocks and Frames

Oracle Forms (2). Working with Data Blocks and Frames. Managing Object Properties. Reentrant Wizard Data Block Wizard Layout Wizard Layout Editor Property Palette. 3. 2. 1. Displaying the Property Palette. To display the Property Palette, use one of the following methods:

vernon-reese
Download Presentation

Working with Data Blocks and Frames

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. Oracle Forms (2) Working with Data Blocks and Frames

  2. Managing Object Properties • Reentrant Wizard • Data Block Wizard • Layout Wizard • Layout Editor • Property Palette 3 2 1

  3. Displaying the Property Palette • To display the Property Palette, use one of the following methods: • Select Tools > Property Palette (or use the shortcut key). • Double-click the object icon in the Object Navigator. • Double-click the object in the Layout Editor. • Right-click the object icon in the Object Navigator. • Right-click the object in the Layout Editor.

  4. Property Palette: Features Find field Toolbar Searchbackward Expand/collapse Searchforward Propertyname Property value Help: Press [F1]

  5. Property Controls Text field More button LOV window Pop-up list

  6. Changed Default Overridden Inherited Property Controls

  7. Visual Attributes • A Visual Attribute is a named set of properties defining: • Font • Color • Pattern

  8. 1. Create a Visual Attribute. 2. Set the Visual Attribute–related property of an object to the desired Visual Attribute. 3. Run the form to see the effect. How to Use Visual Attributes 1 2 3

  9. Font, Pattern, and Color Pickers

  10. Controlling Data Block Behaviorand Appearance • Data Block Property Groups: • General • Navigation • Records • Database • Advanced Database • Scrollbar • Visual Attributes • Color • International

  11. Database Properties • Use properties in the Database group to control: • Type of block—data or control block • Query, insert, update, and delete operations on the data block • Data block’s data source • Query search criteria and default sort order • Maximum query time • Maximum number of records fetched

  12. Displaying Multiple Property Palettes Two Palettes for Two Items: • Two Palettes for One Item:

  13. Setting Properties on Multiple Objects Intersection/ Union

  14. Copying Properties Copy Paste Name ITEMS Query All Records No Query Allowed Yes Insert Allowed Yes Update Allowed Yes Delete Allowed Yes Query All Records Yes Query Allowed Yes Insert Allowed Yes Update Allowed No Delete Allowed Yes Properties Source objects Destination objects

  15. Creating a Control Block • Click the Data Blocks node • Click the Create icon ORSelect Edit > Create. • Select the “Build a new data block manually” option in the New Data Block dialog box.

  16. Deleting a Data Block • Select a data block for deletion • Click the Delete icon ORPress [Delete] • Click Yes in the alert box.

  17. Practice Overview • This practice covers the following topics: • Creating a control block • Creating a Visual Attribute • Invoking context-sensitive help from the Property Palette • Modifying data block properties • Modifying frame properties

  18. Creating LOVs and Editors

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

  20. LOVs and Record Groups Sales Rep record group Employee_id Name SELECT employee_id, first_name || ' '|| last_name NAME, phone_number FROM employees WHERE job_id = 'SA_REP' ORDER BY last_name Sales Representatives LOV EMPLOYEES table

  21. Creating an LOV Manually 1 3 2 4

  22. Creating an LOV with the LOV Wizard:SQL Query Page Edit query if needed

  23. Creating an LOV with the LOV Wizard: Column Selection Page

  24. Creating an LOV with the LOV Wizard: Column Properties Page

  25. Creating an LOV with the LOV Wizard: Display Page

  26. Creating an LOV with the LOV Wizard: Advanced Properties Page

  27. Creating an LOV with the LOV Wizard: Assign to Item Page

  28. LOV Properties Width (X,Y) LOV Height Automatic Select Column Mapping Filter Before Display ? Automatic Skip Return Items

  29. Setting LOV Properties Automatic Column Width LOV Automatic Position Column Mapping Return Items

  30. LOVs: Column Mapping orders.sales_rep_id orders.sales_rep_name orders.salesrep_phone Phone number 1-415-555-6281 Hiddencolumn Employee_id

  31. Defining an Editor

  32. Setting Editor Properties

  33. 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)

  34. Practice 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

More Related