[BENGKEL ORACLE] JUMAAT: 2 NOV 2012

assalamualaikumwarahmatullahiwabarokatuh...

hari 2nd bengkel
pic : En. Ahmad Ruszaini

sambung chapter semalam..chapter 5 smpai chapter 10


untuk chapter 5 - Creating a Master for Detail Form
for this chapter kite akan dapat

1) Create data Blocks with relationship
-create by using data block wizard
-relation Object by using Object Navigator
-creating a relation manually
-join condition will creates primary-foreign key link between blocks
   *define a join condition using:
     - block and item names (not table and column names)
     - Do not precede names with colon
     - SQL equijoin syntax
- deletion properties

2) Modify a data block
-by using property palette
-Coordination Properties
  * default
  * deferred with auto query
  * deferred without auto query
- running a master -detail from module

3) Modify the layout of a data block
- by using frame property palette - change property values
4) Run a master-detail form

untuk chapter 6 -Working with data Blocks and Frames
- Identify the components of the Property Palette
- Manage object properties
- Create and use Visual Attributes
- Control the behavior and appearance of data blocks
-control frame properties
- create blocks that do not directly correspond to database tables
- delete data blocks and their components.

dalam chapter 6 neh byk ajar pasal tukar2 font tukar2 kaler laa..lebey kurang gtuh laa...

Chapter 7 - Working with Text Items
- Text Item for Querying, inserting, updating, deleting
- Modifying the Appearance of a Text Item General and Physical Properties
 * Modify he font and color properties
 * Prompt
- Controlling the Data of a Text Item
 * Format masks
--standard SQL Formats
--Nonstandard formats
- Adding Functionality to a Text Item
 * Conceal Data Property
 * keyboard Navigable and Enabled
 * Multi-line Text Item
 * Help Properties

Note: allow for formats mask's embedded characters when defining Width property.

Chapter 8 - Creating LOVs and Editors (list of values)
- Describe LOVs and Editors
- Design, cretae and associate LOVs with text items in a form module
- Create editors and associate them with text items in a form module.

Chapter 9 - Creating Additional Inputs Item
- Identify the item types that allow input
- create a check box
- create a list item
- create a radio group
- Converting a text item to , a list item, check box item, radio group
- also adding a radio buttons to the radio group.

Chapter 10 - Creating Noninput Items
- Identify items type that do not allow input
- create a display item
- create a button
- create a calculated item
- create a hierarchical tree item
- create a bean area item

cam bese dh habis bengkel silaa la bt exercisee yep^^