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