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

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.

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

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.