View Single Post
  #1 (permalink)  
Old June 27th, 2009, 05:20 AM
peace95 peace95 is offline
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default When should the ORDER_SHIP_DATE be calculated & displayed?

I am in Chapter 8, page 253, The SQL Statement - Creating a Database Trigger. It is this section when the Order Total is set as a trigger using the PL/SQL Code on pp. 250-259. and not displayed as in Figure 8-7, page 249.... Is that correct?

My master-detail page after completing the exercises, from the sections Entering the Validation Code and How It Works, pp.248-250 displays the following:

Buttons: For Edit Order Items: Cancel, Delete, Apply Changes. For Order Item Details only the Create Button is visible;

Items: For Edit Order Items: Customer Name- Name displayed, Date of Order has Calendar I selected and the Order Ship Date which is the coirrect Calculated Date. There are no fields displayed for Order Items Detail just the statement "No data found". At this point, I have a new Order and Order Ship Data but no Detail Order Items....until I Create them by clicking the Create Button.

Should not the Ship Date occur after you have an order complete with Detail Order Items and/or clicking the "Apply Changes" Button. Instead clicking the Edit icon of the newly created order, transfers you back to the master-detail page and an Order Ship date

Please explain...
Thanks In Advance
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.