FetchNextRow method: Business Interlink class

Syntax

FetchNextRow(outputname, value)

where outputname and value are in matched pairs, in the form:

outputname1, value1 [, outputname2, value2] .  .  .

Description

After the Business Interlink object executes the method Execute, the FetchNextRow method can be used to retrieve a row of output and store the values of the output name (outputname) to PeopleCode variables or record fields (value). These must be entered in matched pairs, that is, every output name must be followed by its matching value.

Note:

The output name, not the output path of the interface definition is used for this method.

There must be an outputname for every output name defined in the interface definition used to instantiate the Business Interlink object.

If you specify a record field that is not part of the record the PeopleCode program is associated with, you must use recname.fieldname for that value.

You can specify default values for every output name in the interface definition (created in Application Designer.) These values are used if you create a PeopleCode "template" by dragging the interface definition from the Project window in Application Designer to an open PeopleCode Editor window.

Parameters

Parameter	Description
outputname	Specify the output name. There must be one outputname for every output name defined in the interface definition used to instantiate the Business Interlink object.
value	Specify the value for the output name. This can be a constant, a variable, or a record field. Each value must be paired with an outputname.

Returns

A Boolean value: True if the row of output parameters was fetched. Otherwise, it returns False.

Example

In the following example, the Business Interlink object name is SRA_ALL_1, and the output names, such as costs, are being bound to record fields, such as STR_COST.

&RSLT = &SRA_ALL_1.FetchNextRow("costs", &STR_COST,  
          "unit_costs", &STR_UNIT_COST,  
          "customer_ship_dates", &STR_SHIP_DATE,  
          "quantities", &STR_QUANTITY,  
          "so_numbers", &STR_SO_NUM,  
          "so_names", &STR_SO_NAME,  
          "line_numbers", &STR_LINE_NUM,  
          "ship_sets", &STR_SHIP_SET,  
          "customer_receipt_dates", &STR_RECPT_DATE);