Transcript Les02-Running a Form Builder Application

2
Running a Form
Builder Application
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Objectives
After completing this lesson, you should be able to
do the following:
• Describe the run-time environment
• Navigate a Form Builder application
• Describe the two modes of operation
• Retrieve both restricted and unrestricted data
• Insert, update, and delete records
• Display database errors
2-2
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Run-Time Components
2
1
4
2-3
Copyright Ó Oracle Corporation, 1999. All rights reserved.
3
Run-Time Components
2
1
4
2-4
Copyright Ó Oracle Corporation, 1999. All rights reserved.
3
Data Elements
1
2
3
8
4
9
5
7
2-5
Copyright Ó Oracle Corporation, 1999. All rights reserved.
6
Navigating at Run Time
• Default menu
• Menu toolbar
• Mouse
• Buttons
• Function keys
2-6
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Navigating at Run Time
• Default menu
• Menu toolbar
• Mouse
• Buttons
• Function keys
2-7
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Enter Query Mode
Allows:
Does not allow:
• Unrestricted and
• Navigation out of
restricted queries
• Record count by using
Query—>Count Hits
2-8
current data block
• Exiting run-time session
• Certain functions
• Insert, update, delete
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Normal Mode
Allows:
Does Not Allow:
•
•
•
•
• Restricted queries
• Query/Where dialog box
Unrestricted queries
Insert, update, delete
Commit (Save)
Navigation out of
current data block
• Exiting run-time session
2-9
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Retrieving Data
Unrestricted query
A B
1
2
3
4
C
A B C D
1
2
3
4
2-10
D
Restricted query
A B
3
4
C
D
A B C D
1
2
3
4
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Retrieving Restricted Data
•
Do not use quotation marks with character and
date items.
•
•
•
•
The LIKE operator is implied with % or _.
•
Use quotes around literals in Query/Where.
2-11
Use hash (#) in front of SQL operators.
Use Query/Where for complex query conditions.
Use default date format (DD-MON-YY) in
Query/Where.
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Query/Where Dialog Box
•
Invoke by:
– Entering :variable_name
– Executing query
•
Used to write:
– Complex search conditions
– Queries with OR predicates
– ORDER BY clause
2-12
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Query/Where Dialog Box
2-13
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Making Changes Permanent
Memory
Deletes
Updates
Form module
Inserts
FORMS RUNTIME
Action
ORDERS
Order
or
Item
2-14
Save
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Making Permanent Changes
•
•
2-15
Select Action—>Save to make changes permanent.
Select Action—>Clear All to discard changes.
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Display Error
•
•
•
Use to view Oracle errors
Select Help—>Display Error
Shows:
– SQL statement in error
– Error information
2-16
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Summary
• The run-time environment
• Data elements
• Navigation methods
• Modes of operation:
– Normal mode
– Enter Query mode
2-17
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Summary
•
Retrieving data:
– Restricted queries
– Unrestricted queries
•
•
2-18
Inserting, updating, and deleting data
Displaying errors
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Practice 2 Overview
This practice covers the following topics:
• Running a form application
• Executing unrestricted and restricted queries
• Performing inserts, updates, and deletes in a form
application
•
2-19
Saving changes to the database
Copyright Ó Oracle Corporation, 1999. All rights reserved.