How to Create a Deployable Web Service Using a Multiple-instance Array › Create an EXCEXTFUN to Retrieve the Order Header and Order Details › Load Order Detail Array (Order detail)

Load Order Detail Array (Order detail)

This section explains how to define a function to populate the Order Detail array. The processing runs through the database to find all order detail lines for a given order number. Each detail line is added as a single element in the Order Details array.

Follow these steps:

1. Create a function called LOAD ORDER DETAIL ARRAY, and configure the parameter interface as follows:

   Note: Define the field Total elements as type NBR.

   

2. Define the parameter details as follows:

   

   

3. Configure a LOAD ORDER DETAIL ARRAY: Action Diagram as follows:

   

   

4. Call to the CRT ORDER DETAIL as follows:

   

   

5. Save and exit the function.