p2p.wrox.com Forums - BOOK: Beginning Oracle Application Express ISBN: 9780470388372 http://p2p.wrox.com This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372 Read more about Beginning Oracle Application Express or buy the book from your favorite retailerDownload the code for Beginning Oracle Application Express Buy chapters from this book in PDF en Sat, 21 Nov 2009 07:51:14 GMT vBulletin 60 http://p2p.wrox.com/images/misc/rss.jpg p2p.wrox.com Forums - BOOK: Beginning Oracle Application Express ISBN: 9780470388372 http://p2p.wrox.com Pg.84 Last Paragraph - master detail report/product name http://p2p.wrox.com/book-beginning-oracle-application-express-isbn-9780470388372/77044-pg-84-last-paragraph-master-detail-report-product-name.html Sun, 15 Nov 2009 21:27:41 GMT 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... 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! ]]> BOOK: Beginning Oracle Application Express ISBN: 9780470388372 waylock http://p2p.wrox.com/book-beginning-oracle-application-express-isbn-9780470388372/77044-pg-84-last-paragraph-master-detail-report-product-name.html