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^^