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 .

Hi:
Chapter 9 Limiting Access to Items, pp.284 - 288, exercise #4 on page 286 in particular, does not retain the date entered by the MANAGER. I also read the last paragraph at the bottom of page 287. However, my suspicion for why it is not retaining the entered date is due to the calculation of the ORDER_SHIP_DATE from pp.246-249.

My resolution is as follows:

Code:

1. Return to the development environment and select the master-detail page to edit.
2 Select from Page Processing column>Computatiions Section, Pn_ORDER_SHIP_DATE.
3. Select [Computations] for the PL/SQL code added from Chapter 8.
4. Insert the following after begin:

if :APP_USER = 'MANAGER'

then

return (:Pn_ORDER_SHIP_DATE); where n is the number of master-detail page

else

5. Scroll to bottom of PL/SQL code, just above the return statement, add:

end if;

6. Click Apply Changes.

The above code accepts any and all dates the Manager enters.

QUESTION: Could I have made the the computation conditional instead of unconditional and added the PL/SQL code of the :APP_USER ='MANAGER' statement as Expression1 and the Return(:P4_ORDER_SHIP_DATE) as Expression 2 and get the same results?

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.