Transcript CH5_B
Introduction To Form
Builder
Part B
Eyad Alshareef
1
Objectives
Create data block from view
Modify properties using Property Palette
Text item properties
Master-detail relationship
Create master block first
Specify relationship automatically or manually
Eyad Alshareef
2
Creating a Form Based on a
Database View
View can be derived from one or more database
tables
Form based on a view allows you to display data
from table(s)
Form could be used to insert, update, or delete
data if the view is a simple view only.
Eyad Alshareef
3
Creating a Form Based on
a Database View
Similar to form based on table but read-only
Eyad Alshareef
4
Modifying Properties
Eyad Alshareef
5
Modifying Form Properties
Eyad Alshareef
6
Guidelines For Configuring
Form Windows
1.
2.
3.
4.
5.
6.
Change the window title
Allow user to minimize the window
Do not allow the user to maximize the window
Do not allow the user to resize the window
Include horizontal and vertical scrollbars if items
appear beyond window boundaries
Make the form window fill the Forms Runtime
window
Eyad Alshareef
7
Configuring Form Windows
Window
Title
Minimize/
Maximize buttons
Eyad Alshareef
Window
size
8
Property Palette
Eyad Alshareef
9
Modifying Form Properties
Every form object has a Property Palette that
allows you to configure form properties
Property
Nodes
Property List
Eyad Alshareef
10
Modifying Form Properties
Use Property Palette of form object to
modify desired properties
To
access: right click object, select Property
Palette from menu
Intersection mode modifies properties for
multiple objects at the same time
To open in intersection mode, select multiple
objects before opening Property Palette
Eyad Alshareef
11
Property Palette
Eyad Alshareef
12
Intersection Property Palette
Used to change property of several items to the
same value
Intersection/Union button appears as
Name appears as *****
Eyad Alshareef
13
Frame Properties
Update Layout
Automatically
Manually
Frame items are automatically repositioned based on their order in
the Data Blocks list when you move or resize a frame, or modify the
form layout using the Layout Wizard in reentrant mode
Items are automatically when layout is modified in Layout Wizard in
reentrant mode
Items are not repositioned if you move or resize the frame
Locked
Items are never automatically repositioned
Eyad Alshareef
14
Modifying Text Item Properties
Using the Property Palette
Intersection mode
Values appears as **** when objects have different
values
Text item properties
Control how users enter data values
How form displays data values
Hint
ToolTip
Eyad Alshareef
15
Text item Appearance Properties
Eyad Alshareef
16
Text Item Data Value Properties
Eyad Alshareef
17
Text Item Database Properties
Eyad Alshareef
18
Master-detail
relationship
Eyad Alshareef
19
Multiple-Table Forms
Data block forms can display data from multiple
tables that have a master-detail relationship
Master record has multiple related detail records
Examples:
One ITEM record has multiple related INVENTORY
records
One CUSTOMER might have multiple CUST_ORDER
records
Eyad Alshareef
20
Creating the Detail Data Block
Master-Detail page
Auto-join feature of Data Block Wizard
Create link manually
Click Create Relationship
Explicitly select related items
Join Condition field syntax:
detail_block.join_item =
master_block.join_item
Eyad Alshareef
21
Master-Detail Forms
Master block
Detail block
Eyad Alshareef
22
Multiple Master-Detail Blocks
Eyad Alshareef
23
Creating a Master-Detail Form
Create the master
block first
Specify the
relationship on
the Data Block
Wizard MasterDetail page of
the detail block
Eyad Alshareef
24
Complex Master-Detail
Relationships
A master block can have multiple detail blocks
An item can be in multiple customer orders, and have
multiple shipment records
A detail block can be a master block in a second
master-detail relationship
A customer can have multiple CUST_ORDER records
One CUST_ORDER record can have multiple
ORDER_LINE records
Eyad Alshareef
25
Complex Master-Detail
Relationship Example
Master
Detail
Detail
Master
Eyad Alshareef
26
Creating a form based on two linked tables
In order to create a form based on 2 tables:
Create a form similar to the STUDENT form we created
(name it REGISTRATION)
Create an additional data block using a wizard
Establish master-detail relationship
Eyad Alshareef
27
Creating a form based on two
linked tables
Follow the steps suggested by the wizard
Eyad Alshareef
28
Creating a form based on two
linked tables
For the STUD_COURSE frame, select tabular
layout, 4 records per page and a scrollbar.
Eyad Alshareef
29
Compile and run your form
Eyad Alshareef
30
Formatting Mask
Eyad Alshareef
31
Formatting Text Items
Specify desired format mask in text item Format
Mask property
If format mask makes value wider than text item
Data Width property, data appears as #####
E.g: make the format mask for the empno field in the
form builder: 99”- - “ 99 and make the data length for the
field 4.
Eyad Alshareef
32
Formatting Character Text Items
Place embedded characters in double quotes
Eyad Alshareef
33
Format Mask Examples
Value
Format Mask
Result
7945
999
###
7945
9999$
7945$
7945
99”-”99
79-45
34.28
99.9
34.3
34.28
99.999
34.280
SYSDATE Day-MON-YY Friday-NOV-06
Eyad Alshareef
34