1 / 35

Week 5 February 22

This article provides tips and solutions for addressing errors and problems encountered while using Object Linking and Embedding (OLE) in Oracle Forms. It also explains the architecture and features of OLE and gives an overview of creating an OLE container. Additionally, it covers the principles and dimensions of designing a report in Oracle Forms.

shellye
Download Presentation

Week 5 February 22

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Week 5February 22 Dealing with Errors and Problems OLE: Object Linking and Embedding Anatomy of a Report

  2. Query 2 select manufacturer_name, manufacturer_code from manufacturers where manufacturer_code = :q1_manufacturer_code Query 3 select product_code, product_description, retail_price from products where manufacturer_code = :q2_manufacturer_code Query 1 select manufacturer_name, manufacturer_code from manufacturers order by manufacturer_name

  3. Query 4

  4. Dealing with Errors and Problems

  5. Launching a Query To begin a query, the form must first be in query mode

  6. Ending a Form Without Entering a Query FRM-40353 Error

  7. Attempting a Query While Not in Query Mode

  8. FRM-40301 Error

  9. Overcoming Problems with Triggers • Maximize the MDI and form module windows • Enter query mode when the form is launched • Re-enter query mode after every query • Cancel the query if no query is entered when exiting the form • Suppress system alerts and messages

  10. Add and program the WHEN-NEW-FORM-INSTANCE and WHEN-NEW-RECORD-INSTANCE triggers Because these triggers are at the top of the hierarchy, the will be executed first. Add and program the WHEN-MOUSE-CLICK trigger Note: This was taken from another form module

  11. Local variables needed to capture the error code and launch the alert Prefix “A” for alert.

  12. Re-enters query mode after a prior query

  13. Eventually... Content canvas Tab canvas

  14. OLE: Object Linking and Embedding

  15. Object Linking and Embedding (OLE) • Allows the developer to link or embed objects within other files objects • An object can be a document, spreadsheet, graphic (GIF, TIF, JPEG, etc.), etc.

  16. OLE Architecture • Divides tools into OLE servers and containers • Server - an application that creates and serves OLE objects in other applications • Container - an application that provides facilities for creation, manipulation and storage of OLE objects

  17. OLE Oracle Form Module Link Container (embedding) Excel (server) Spreadsheet (object)

  18. Access • Activation - connecting to the server application and using its features to manipulate and display the object • In-place Activation • Activates within the container application • Focus on the object • External Activation (default) • Activates within the server application • Object updated upon close

  19. Create the OLE Container  Select the Property Palette OLE Container  Create the OLE Container with the OLE button in the tool palette

  20. Change the Resize Property

  21. Assign a File or Application to the OLE

  22. Opening an Existing File  Display an icon in the OLE container   Select the file

  23. During Runtime Double click on the icon Quick Time Player (designated Windows plug-in) launched to play the movie file

  24. Anatomy of a Report

  25. Principles of Design A report should... • Communicate information to the user • Be flexible to adapt to different needs, levels of experience and knowledge of the intended user • Be simple, and no simpler

  26. Dimensions of a Report Page Line Column

  27. Report Page Elements Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Total Amount Transacted: 56,587.50

  28. Report Header Date Processed 02/12/06 Page 1 Razorback Securities, Inc. Transaction Listing Appears at the beginning of the report and only once.

  29. Report Page Elements: Page Heading Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Appears on every page Total Amount Transacted: 56,587.50

  30. Report Page Elements: Title Line Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Usually appears on every page Total Amount Transacted: 56,587.50

  31. Report Page Elements: Headings Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Total Amount Transacted: 56,587.50

  32. Report Page Elements: Body Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Detail line Total Amount Transacted: 56,587.50

  33. Report Page Elements: Footings Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Listing Date Acct. No.Trans Exch Security Shares Price 02/01/96 72150391 B NYSE 23046 Ford Motor 100 10 1/4 1,025.00 02/02/96 72150391 S NYSE 69247 Texas Instr 700 79 3/8 55.562.50 Total Amount Transacted: 56,587.50

  34. Report Page Elements: Summary Date Processed 02/12/06 Page 2 Razorback Securities, Inc. Transaction Summary Total Amount Transacted: 2,333,875.00

More Related