No Slide Title - Sacramento State by yurtgc548

VIEWS: 0 PAGES: 35

									                                                                       1




                                                    Week 5
                                                  February 22

                       • Dealing with Errors and Problems
                     • OLE: Object Linking and Embedding
                             • Anatomy of a Report


R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                          Query 2
                                          select manufacturer_name, manufacturer_code
                                          from manufacturers
                                          where manufacturer_code = :q1_manufacturer_code
                                                                                        2

                                           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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                                 3



                                                                       Query 4




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                       4




    Dealing with Errors and Problems




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                          Launching a Query                              5


                                                                       To begin a query,
                                                                       the form must first
                                                                       be in query mode




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
          Ending a Form Without Entering a Query                                     6




                                                                       FRM-40353 Error




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Attempting a Query While Not in Query Mode                          7




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                                     8




                                                                       FRM-40301 Error




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Overcoming Problems with Triggers                                  9



    • 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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                    Add and program the                   10
                                                    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


R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                       11




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                                               12
                                                    Local variables needed to capture the
                                                    error code and launch the alert




                                                                       Prefix “A” for alert.




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                       13
                        Re-enters query mode after a prior query




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Eventually...                                                          14


                                                                       Content
                                                                       canvas




                                                                        Tab
                                                                       canvas




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                                                       15




    OLE: Object Linking and Embedding




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Object Linking and Embedding (OLE)                                 16



    • 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.




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    OLE Architecture                                                   17



    • 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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   OLE                                                                                         18

Oracle Form
  Module




                    Container                                    Link
                  (embedding)                                                    Excel (server)

                                                                        Spreadsheet (object)



R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Access                                                              19


   • 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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
      Create the OLE Container                                                                    20




                                                                   Select the Property Palette

OLE Container

        Create the OLE Container with the OLE button in
         the tool palette




  R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                             Change the Resize Property                21




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
            Assign a File or Application to the OLE                    22




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                  Opening an Existing File                                    23


                                                                        Display an icon in
                                                                        the OLE container
                           Select the file




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
                                               During Runtime                                 24


 Double
 click on
 the icon

                                                                       Quick Time Player
                                                                       (designated Windows
                                                                       plug-in) launched to play
                                                                       the movie file




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Anatomy of a Report                                                 25




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Principles of Design                                               26



    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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Dimensions of a Report                                                         27

                                                                           Page

                                                                          Line




                                                                 Column

R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Report Page Elements                                                                                28

             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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Report Header                                                                       29

             Date Processed 02/12/06                                          Page 1
                                                 Razorback Securities, Inc.
                                                    Transaction Listing


Appears at the beginning of the report and only once.




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Report Page Elements: Page Heading                                                                  30

              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




 R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Report Page Elements: Title Line                                                                    31

              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




 R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Report Page Elements: Headings                                                                      32

             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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
    Report Page Elements: Body                                                                          33

              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




 R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Report Page Elements: Footings                                                                      34

             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




R. Ching, Ph.D. • MIS Area • California State University, Sacramento
   Report Page Elements: Summary                                                       35

             Date Processed 02/12/06                                          Page 2
                                                 Razorback Securities, Inc.
                                                  Transaction Summary



                                      Total Amount Transacted: 2,333,875.00




R. Ching, Ph.D. • MIS Area • California State University, Sacramento

								
To top