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 November 15th, 2009, 05:27 PM
Registered User
Join Date: Nov 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pg.84 Last Paragraph - master detail report/product name

In the last paragraph of this chapter on Pg. 84, the author challenges the reader to attempt to change the PRODUCT_ID column for the PRODUCT_NAME column in the master detail report in Order Items Detail.

I've had a problem doing this successfully. I was able to get it to work but it showed all orders instead of the specific order. To no avail, I was unable to get it to work.

A couple issues which seemed to be different than the previous exercise spanning pages 81-84.

1. The report doesn't show up as an "Interactive Report". I got around this by creating a new Region which was an Interactive Report. I then copied the following SQL into that report:


2. I also have some confusion around the difference between the Report on Products Page and the Order Items Page since the later seems to be a "Form" and how that relates back to the task at hand.

3. A non-related question, somehow along the way my pages have different numbers than the examples in the book which adds confusion while trying to follow along. Can I easily change the page name/number to reflect the same number scheme used in the book?

Thank you!
Old November 15th, 2009, 07:07 PM
Registered User
Join Date: Nov 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Revised - Pg.84 Question

I read on into Chapter 4 and my first question was answered. I'm still processing it all thought.

Old November 20th, 2009, 03:45 PM
Friend of Wrox
Join Date: May 2005
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts


Athough I have been through the entire book, I had to go back and review what is actually happening.
2. In pages 81-84, one of the main points to capture is creating or using a table as your LOV (List of Values) in the Master-Detail when ordering items. When order items, the customer is not concern about the product.id per se just the product name. However the product.id is past to the detail portion of the report, in this case the product form.

3. I would not suggest to change the page numbers, because if you notice in the process page some pages are automatically set for example in a redirect, etc. However, I strongly suggest when you finish an exercise to pencil in your book the page or pages apex created. The pages I really remembered by heart is the Master-Detail page number, it is used throught out the book and I started over 3 times.

Have fun!! You will learn much.
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.

Last edited by peace95; November 20th, 2009 at 03:48 PM..

Similar Threads
Thread Thread Starter Forum Replies Last Post
Master-Detail Crystal Report in Asp.Net 3.5 saimahesh ASP.NET 3.5 Professionals 1 July 29th, 2009 05:07 AM
master-detail hhpatek ADO.NET 0 April 3rd, 2008 02:53 PM
Master Detail prasanta2expert Access VBA 1 October 1st, 2007 06:37 AM
master detail windows from using C# kamran Yousaf Bk Classic ASP Professional 0 January 12th, 2007 06:39 AM
master/detail beeyule Dreamweaver (all versions) 1 January 18th, 2005 02:59 AM

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