1 / 26

Working with Data Blocks and Frames

Working with Data Blocks and Frames. Objectives. After completing this lesson, you should be able to do the following: Identify the components of the Property Palette Manipulate properties through the Property Palette Control the behavior and appearance of data blocks. Objectives.

jhenke
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. Working with Data Blocks and Frames

  2. Objectives After completing this lesson, you should be able to do the following: • Identify the components of the Property Palette • Manipulate properties through the Property Palette • Control the behavior and appearance of data blocks

  3. Objectives • Control frame properties • Create blocks that do not directly correspond to the database • Delete data blocks and their components

  4. Modifying the Appearance and Behavior of Data Blocks • Reentrant wizards • Layout Editor • Data Block Property Palette • Frame Property Palette

  5. Displaying the Property Palette Use one of several methods: • Select Tools—>Property Palette. • Double-click the object icon in the Object Navigator. • Double-click the object in Layout Editor. • Click the right mouse button.

  6. Find field Toolbar Search Expand/ Backward Collapse Search Forward Property Property name value Property Palette Features

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

  8. Visual Attributes • Visual attributes: • Are font, color, and pattern properties • Can be set for form and menu objects • A visual attribute is a form object with font, color, and pattern properties. • Set the Visual Attribute Group property to the visual attribute object.

  9. Font, Pattern, and Color Picker

  10. Data Block Properties

  11. Data Block Property Groups • General • Navigation • Records • Database • Advanced Database • Scrollbar • Font and Color • Character Mode • International

  12. Previous Navigation Data Block Same Record Next Record Next Navigation Data Block Navigation Properties ORDERS Order Item

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

  14. Database Properties Records buffered Records fetched Block display SELECT .... WHERE Clause [ORDER BY Clause] Work file

  15. Records Properties Vertical Record Orientation Horizontal Record Orientation

  16. Records Properties Item Current Record Number of Records Displayed

  17. Scroll Bar X/Y Position Scroll Bar Height Scroll Bar Width Scroll Bar Properties Item

  18. Frame Properties ORDERS Order Form Layout Style Item Tabular Layout Style Distance between records

  19. Multiple Property Palettes • Display multiple Property Palettes for an object: • Open a Property Palette for the object. • Hold down the [Shift] key and double-click the object icon for an additional palette. • Display Property Palettes for the multiple objects: • Open the Property Palette for first object. • Click the Freeze/Unfreeze button on the toolbar. • Invoke Property Palette for the next object.

  20. Intersection/ Union Setting Properties on Multiple Objects

  21. Copying Properties Copy Paste Name S_ITEM Query All Records Yes Query Allowed Yes Insert Allowed Yes Update Allowed No Delete Allowed Yes 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 Query All Records No Query Allowed Yes Insert Allowed Yes Update Allowed Yes Delete Allowed Yes Properties Source objects Destination objects

  22. Creating a Control Block • Click the Data Blocks node and click the Create icon. or Select Navigator—>Create. • Select the “Build a new data block manually” option in the New Data Block dialog box.

  23. Deleting a Data Block • Select a data block for deletion and click the Delete icon. or Select Navigator—>Delete. • Click Yes in the alert box.

  24. Summary • Modify the data block properties in its Property Palette to change its behavior. • Data blocks have Navigation, Database, Records, Scrollbar and other properties. • Database properties include WHERE Clause, Query Data Source, and Maximum Records Fetched. • Change frame properties to modify the arrangements of items within a data block.

  25. Summary • A control block is not associated with the database. • Copy properties between data blocks and other objects. • View and change properties of several objects together (Intersection/Union).

  26. Practice 5 Overview This practice covers the following topics: • Creating a control block • Creating a visual attribute • Modifying data block properties • Modifying frame properties

More Related