Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > BOOK: Beginning Oracle Application Express ISBN: 9780470388372
BOOK: Beginning Oracle Application Express ISBN: 9780470388372
This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Oracle Application Express ISBN: 9780470388372 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 27th, 2009, 05:20 AM
Friend of Wrox
Join Date: May 2005
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.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculated control on report penta Access 2 June 13th, 2005 06:04 AM
Linux & KDE & C++ & QT & MYSQL & Kdevelop Munnnki Linux 0 January 2nd, 2005 05:41 PM
Storing Calculated Fields dearnne Access 3 September 2nd, 2004 05:30 PM
Storing Calculated Fields dearnne Access VBA 1 August 30th, 2004 10:54 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.