week 4 february 15
DESCRIPTION
Week 4 February 15. LOV: List of Values Dealing with Errors and Problems OLE: Object Linking and Embedding. LOV. Items. Detail Data Block. Tab canvas. Working with Multiple Canvases and Data Blocks. Menu. Window. Master Data Block. Content canvas. Items. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/1.jpg)
1
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Week 4Week 4February 15February 15
• LOV: List of ValuesLOV: List of Values• Dealing with Errors and ProblemsDealing with Errors and Problems
• OLE: Object Linking and EmbeddingOLE: Object Linking and Embedding
![Page 2: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/2.jpg)
2
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Working with Multiple Canvases Working with Multiple Canvases and Data Blocksand Data Blocks
WindowWindow
Master Data BlockMaster Data Block
Tab canvasTab canvas
Content canvasContent canvas
ItemsItems
Detail Data BlockDetail Data Block
ItemsItems
MenuMenu MenuMenuLOVLOV
![Page 3: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/3.jpg)
3
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Tab CanvasTab Canvas
Data blockData block
Data blockData block
User enters a codeUser enters a code
How many users will remember all the codes?How many users will remember all the codes?How many users will remember all the codes?How many users will remember all the codes?
![Page 4: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/4.jpg)
4
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
LOV (list of values)LOV (list of values)
Code transferred into boxCode transferred into box
![Page 5: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/5.jpg)
5
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
![Page 6: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/6.jpg)
6
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
![Page 7: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/7.jpg)
7
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Principles of DesignPrinciples of Design
A form or reports should...A form or reports should...
• CommunicateCommunicate information to the user information to the user
• Be Be flexibleflexible to adapt to different needs, levels of to adapt to different needs, levels of experience and knowledge of the intended userexperience and knowledge of the intended user
• Be Be simplesimple, and no simpler, and no simpler
• PerformPerform to match the flow and speed of the user to match the flow and speed of the user
• Provide assistanceProvide assistance to its users through feedback and the to its users through feedback and the ability to undo errorsability to undo errors
![Page 8: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/8.jpg)
8
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
FlexibilityFlexibility
• FlexibilityFlexibility: The degree to which users can adapt the : The degree to which users can adapt the application to their intended useapplication to their intended use
– Provide different paths for different levels of Provide different paths for different levels of experienceexperience
![Page 9: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/9.jpg)
9
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
SimplicitySimplicity
• Hide levels of complexity
• Simplify the common tasks
• Limit the number of interface elements
• Make interface element consistent and cohesive
– Frequency, sequence, importance and function
• Minimize redundancy and complexity of paths
• Use standards to guide users
• Automate data entry to improve reliabilityAutomate data entry to improve reliability
– Default values, Default values, list of valueslist of values, , triggerstriggers
![Page 10: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/10.jpg)
10
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Sequence of Events...Sequence of Events...
• Create the content canvasCreate the content canvas
– Add the master data blockAdd the master data block
– Program the triggersProgram the triggers
• Create the tab canvasCreate the tab canvas
– Add the detail data blockAdd the detail data block
• Create and attach the LOV (list of values)Create and attach the LOV (list of values)
• Menu added through inheritance (i.e., call_form)Menu added through inheritance (i.e., call_form)
• Fine tune the form moduleFine tune the form module
![Page 11: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/11.jpg)
11
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
LOV: List of ValuesLOV: List of Values
![Page 12: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/12.jpg)
12
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
List of Values (LOV)List of Values (LOV)
• Used to authenticate or automate the selection of values Used to authenticate or automate the selection of values from a listfrom a list
• Returns Returns valuesvalues to other items (e.g., data block item) to other items (e.g., data block item)
• Modal (popup) windowModal (popup) window
• Search function Search function
– Handle large listsHandle large lists
• Can be filled by a query Can be filled by a query (dynamic list) or a static list(dynamic list) or a static list
LOVLOV
![Page 13: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/13.jpg)
13
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
LOV and Record GroupsLOV and Record Groups
LOVLOV
Record Record GroupGroupDefineDefine
ValuesValues
Manufacturer NameManufacturer NameManufacturer codeManufacturer code
Values
Values
![Page 14: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/14.jpg)
14
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Creating an LOVCreating an LOV
• Create the LOV through the Create the LOV through the LOV WizardLOV Wizard
– Build the SQL query that creates the listBuild the SQL query that creates the list
– Select and assign the Select and assign the return valuereturn value to the data block to the data block itemitem
• Assign the LOV to the data blockAssign the LOV to the data block
• Program a trigger that will display the LOVProgram a trigger that will display the LOV
![Page 15: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/15.jpg)
15
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Creating an LOVCreating an LOV
CreateCreate In the In the Object NavigatorObject Navigator, select , select LOVsLOVs
Click on Click on CreateCreate in the tool palette in the tool palette
Select the Select the LOV WizardLOV Wizard
![Page 16: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/16.jpg)
16
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Enter the Enter the queryquery
Check your SQL syntaxCheck your SQL syntax
![Page 17: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/17.jpg)
17
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Specify the columns for the LOVSpecify the columns for the LOV
![Page 18: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/18.jpg)
18
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Specify the Specify the ReturnReturn Value Value
manufacturers.manufacturer_codemanufacturers.manufacturer_codemanufacturers.manufacturer_codemanufacturers.manufacturer_code
Prevents the column from Prevents the column from appearingappearing in the LOV in the LOV
Enter the return Enter the return valuevalue for the data block for the data block
![Page 19: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/19.jpg)
19
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Assign the Return Item for the Data BlockAssign the Return Item for the Data Block
Assign the column to returnAssign the column to return
![Page 20: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/20.jpg)
20
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Object NavigatorObject Navigator
LOV will have a record group associated with itLOV will have a record group associated with it
![Page 21: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/21.jpg)
21
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Record GroupRecord Group
Edit the query through Edit the query through the record group’s the record group’s property paletteproperty palette
![Page 22: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/22.jpg)
22
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Assign the LOV to the Data BlockAssign the LOV to the Data Block
![Page 23: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/23.jpg)
23
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Assign the LOV to the Data BlockAssign the LOV to the Data Block
![Page 24: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/24.jpg)
24
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Program the TriggerProgram the Trigger
Displays the LOVDisplays the LOV
Executes the query when the Executes the query when the OKOK button is pressed button is pressed
An alternative to using <F9>An alternative to using <F9>An alternative to using <F9>An alternative to using <F9>
![Page 25: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/25.jpg)
25
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
The user can either The user can either double-click or double-click or press <F9> to press <F9> to launch the LOVlaunch the LOV
![Page 26: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/26.jpg)
26
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Dealing with Errors and ProblemsDealing with Errors and Problems
![Page 27: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/27.jpg)
27
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Launching a QueryLaunching a Query
![Page 28: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/28.jpg)
28
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Ending a Form Without Entering a QueryEnding a Form Without Entering a Query
FRM-40353 ErrorFRM-40353 Error
![Page 29: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/29.jpg)
29
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Attempting a Query While Not in Query ModeAttempting a Query While Not in Query Mode
![Page 30: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/30.jpg)
30
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
FRM-40301 ErrorFRM-40301 Error
![Page 31: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/31.jpg)
31
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Overcoming Problems with TriggersOvercoming Problems with Triggers
• Maximize the MDI and form module windowsMaximize the MDI and form module windows
• Enter query mode when the form is launchedEnter query mode when the form is launched
• Re-enter query mode after every queryRe-enter query mode after every query
• Cancel the query if no query is entered when exiting the Cancel the query if no query is entered when exiting the formform
• Suppress system alerts and messagesSuppress system alerts and messages
![Page 32: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/32.jpg)
32
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Add and program the Add and program the WHEN-NEW-FORM-INSTANCEWHEN-NEW-FORM-INSTANCE and and WHEN-NEW-RECORD-INSTANCEWHEN-NEW-RECORD-INSTANCE triggerstriggers
Add and program the Add and program the WHEN-MOUSE-CLICKWHEN-MOUSE-CLICK trigger trigger
Note: This was taken from another form moduleNote: This was taken from another form module
![Page 33: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/33.jpg)
33
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
![Page 34: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/34.jpg)
34
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Local variables needed to capture the Local variables needed to capture the error code and launch the alerterror code and launch the alert
![Page 35: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/35.jpg)
35
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Re-enters query mode after a prior queryRe-enters query mode after a prior query
![Page 36: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/36.jpg)
36
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Content Content canvascanvas
Tab Tab canvascanvas
Eventually...Eventually...
![Page 37: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/37.jpg)
37
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
OLE: Object Linking and Embedding OLE: Object Linking and Embedding
![Page 38: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/38.jpg)
38
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Object Linking and Embedding (OLE)Object Linking and Embedding (OLE)
• Allows the developer to link or embed objects within other Allows the developer to link or embed objects within other files objectsfiles objects
– An object can be a document, spreadsheet, graphic An object can be a document, spreadsheet, graphic (GIF, TIF, JPEG, etc.), etc.(GIF, TIF, JPEG, etc.), etc.
![Page 39: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/39.jpg)
39
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
OLE ArchitectureOLE Architecture
• Divides tools into OLE servers and containersDivides tools into OLE servers and containers
– Server - an application that creates and serves OLE Server - an application that creates and serves OLE objects in other applicationsobjects in other applications
– Container - an application that provides facilities for Container - an application that provides facilities for creation, manipulation and storage of OLE objectscreation, manipulation and storage of OLE objects
![Page 40: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/40.jpg)
40
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
OLEOLE
Container Container (embedding)(embedding)
LinkLink
Spreadsheet Spreadsheet (object)(object)
Excel (server)Excel (server)
Oracle Form Oracle Form ModuleModule
![Page 41: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/41.jpg)
41
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
AccessAccess
• Activation - connecting to the server application and using Activation - connecting to the server application and using its features to manipulate and display the objectits features to manipulate and display the object– In-place ActivationIn-place Activation
• Activates within the container applicationActivates within the container application• Focus on the objectFocus on the object
– External Activation (default)External Activation (default)
• Activates within the server applicationActivates within the server application
• Object updated upon closeObject updated upon close
![Page 42: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/42.jpg)
42
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Create the OLE ContainerCreate the OLE Container
OLE ContainerOLE Container
Create the Create the OLE ContainerOLE Container with the with the OLEOLE button in button in the tool palettethe tool palette
Select the Select the Property PaletteProperty Palette
![Page 43: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/43.jpg)
43
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Change the Resize PropertyChange the Resize Property
![Page 44: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/44.jpg)
44
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Assign a File or Application to the OLEAssign a File or Application to the OLE
![Page 45: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/45.jpg)
45
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
Opening an Existing FileOpening an Existing File
Select the fileSelect the file
Display an icon in Display an icon in the OLE containerthe OLE container
![Page 46: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/46.jpg)
46
R. Ching, Ph.D. • MIS Area • California State University, Sacramento
During RuntimeDuring Runtime
Double Double click on click on the iconthe icon
Quick Time Player Quick Time Player (designated Windows (designated Windows plug-in) launched to play plug-in) launched to play the movie filethe movie file
![Page 47: Week 4 February 15](https://reader036.vdocuments.us/reader036/viewer/2022062305/568158e9550346895dc628bf/html5/thumbnails/47.jpg)
47
R. Ching, Ph.D. • MIS Area • California State University, Sacramento