Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| 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
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 14th, 2010, 06:41 PM
Registered User
 
Join Date: Nov 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default validation problem Chapter 8

I'm up to page 265 in Chapter 8 and so far everything worked fine and I've seen all the expected results. However, I cannot get the validation CREDIT_LIMIT_CHECK to work. I've repeated this section several times with the same result (see below). I've checked the code and made sure the Pn's were all properly replaced. I've back checked my previous work and everything seems ok - so I would appreciate any suggestions to get around this. The credit limit has been set to $1000 for all Customers.

On an existing order I can enter any exorbitant amount above $1000 and nothing happens. It seems as if the validation isn't functional.

However, if I run the page (4 for my system), click cancel to go back one page (page1) and start by creating a new order, it then switches to page 4, the Edit Order Items page, displays Customer Name, Date of Order, Order Ship Date and Order total (the last 2 are blank). The only two buttons present are "Cancel" and "Create". If I click "Create" I get the errors below

the errors are:
ORA-01403: no data found
ERR-1024 Unable to run "function body returning text" validation
Return to application

The first error is understandable because at that point there IS NO DATA. However I don't understand ERR-1024

If I alter the the CONDITIONS and set "when button pressed" to SAVE, "condition type" to Request - Expression 1 and set "Expression 1" to SAVE - the errors go away but validation still doesn't work.

Any help or suggestions will be appreciated

The way the book has this set up, the CONDITIONS clause will cause the validation to fire if any button other than DELETE is pressed. Unfortunately you have to press CREATE in order to open the "Order Items Detail" dialog
  #2 (permalink)  
Old January 15th, 2010, 07:00 AM
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

Glenn:
Luckily I made copies of the displayed page and the edit page that produced the displayed. Observing my book on page 261 for the n value for :Pn_ORDER_ID in the grayed highlighted box I have n= 1, which yeilds P1_ORDER_ID. This is needed to connect the Order Details to the Customer.

When you create the details to a new order or make modifications which exceeds the total, there error message in figure 8-16 shoud appear.

Just a note beginning chapter 8, some of the screens may not look exactly like the ones in the book, but the functionality is the same.

Hope this helps.
__________________
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.
  #3 (permalink)  
Old January 15th, 2010, 01:35 PM
Registered User
 
Join Date: Nov 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default still unvalidated

Hi peace95

Thanks for trying to help. I tried your suggestion of :P1_ORDER_ID but it makes no difference - validation still doesn't work and I still get the error as previously described.

I don't think it really matters whether it is :P1 or :P4 because the Order_Id appears on both pages - it is just a hidden field on :P4. However, changing to :P1 caused an additional problem. If I change an exising order, add a new item >$1000 which returns it to page 4 (validation doesn't fire) but when I click "Apply Changes" I now get the same error messages for this button. This did not happen when it was set to :P4

I can only assume I did something wrong in a previous step - yet everything worked.

The thing I really don't like about Apex is the myriad of little cubbles that have to be dealt with and as a beginner in Apex, I find the book doesn't provide good explanations of what each entry means. Some are quite obvious but others are definately not.

It reminds me of the old Dungeon text game that starts with something like "you are about to enter a maze of twisty little pasages heading down". You've got to be old enough to appreciate that.

I'm going to spend a few days chewing through the manuals and then come back to finish the last few chapters. I need to get a working application under way

Again. Thanks for trying to help
  #4 (permalink)  
Old January 16th, 2010, 01:32 AM
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

Glenn:
fortunately I made copies of the pages along with its Edit page. Before we start comparing pages, Begore comparing the Edit Pages of chapter 8, I suggest:
  • Check Customer, Order and Order_Items to make sure that ORDER_ID is the same, which is al uppercase;
  • For APEX pages 1-5, the Validations on the Edit Page 5 is where the CREDIT_LIMIT_CHECK is located. Is it the same on your APEX page, if not what page?
We can go over the pages startng with chapter 8, but it maight be best to do it outside of the forum. Let me know.
__________________
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.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Chapter 2 Package validation error LesThompson BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 0 October 24th, 2008 01:19 PM
Chapter 15 - EMail Validation studentinpain BOOK: Beginning ASP 3.0 1 March 19th, 2004 07:33 AM



All times are GMT -4. The time now is 07:39 AM.


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