Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > BOOK: Beginning Oracle Application Express ISBN: 9780470388372
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 15th, 2009, 04: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:

select "ORDER_ITEMS"."ORDER_ID" as "ORDER_ID",
"PRODUCTS"."PRODUCT_NAME" as "PRODUCT_NAME",
"ORDER_ITEMS"."UNIT_PRICE" as "UNIT_PRICE",
"ORDER_ITEMS"."QUANTITY" as "QUANTITY"
from "PRODUCTS" "PRODUCTS",
"ORDER_ITEMS" "ORDER_ITEMS"
where "PRODUCTS"."PRODUCT_ID"="ORDER_ITEMS"."PRODUCT _ID"
order by ORDER_ITEMS.ORDER_ID ASC


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!
Reply With Quote
  #2 (permalink)  
Old November 15th, 2009, 06: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.

Thanks,
Reply With Quote
  #3 (permalink)  
Old November 20th, 2009, 02:45 PM
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

waylock:

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 02:48 PM.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 05:39 AM
master/detail beeyule Dreamweaver (all versions) 1 January 18th, 2005 01:59 AM



All times are GMT -4. The time now is 07:37 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.