p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning Oracle Application Express ISBN: 9780470388372 (http://p2p.wrox.com/forumdisplay.php?f=474)
-   -   Error message not updated. (http://p2p.wrox.com/showthread.php?t=79442)

FrankJSpina May 17th, 2010 09:48 PM

Error message not updated.
 
Chapter 6, p 195, items 3 through 8. I changed the default error message and the new message only appears when I log into the application and select the Purchases by Customer tab with the % in the Customers drop down list. Otherwise I get the "old" default error message from Figure 6-27. Any clues as to why the new error message isn't appearing other than at first access after application login?

FrankJSpina May 18th, 2010 11:27 AM

Solved the problem, sort of...
 
After looking at the debugger statements and after playing with the query returning the data for the Flash Chart, I realized that if the query truly found no records then the appropriate error message was displayed. I edited the Null Return Value of the Pn_CUSTOMERS list of values to 99999 (a CUSTOMER_NAME_ID that will hopefully never exist) and the appropriate message is now being displayed when choosing the "wildcard" value from the Customer dropdown list.

Given the fact that the book assumes the error message worked appropriately without having to make other changes, I'm concerned that I had to figure this out and now I'm wondering if I screwed up somewhere along the line when doing the tutorials in Chapter 6 (or earlier!).

hedwardmarsh January 25th, 2013 05:53 AM

hi this is Hedward Marsh, i am beginner to oracle i am searching for oracle based questions and errors and solutions i found this website in this website i found very useful information thanks for posting job description


All times are GMT -4. The time now is 04:50 PM.

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