Lesson 8: Creating an Order Entry Program

This lesson describes how to create an order entry program having two interactive procedures. The first gets details of the order header and updates the ORDER_HEADER table. The second uses the Window access mode to display a list of existing ORDER_LINE records from which the user may select one for update. As order entry proceeds, the program totals the order line value into the order value and performs stock validation and adjustment and also checks that the customer does not exceed his credit limit.

·   Creating the ORD_HEADER Procedure

·   Creating the ORDER_LINE Procedure