/* getCustOrdersBI.p */
DEFINE TEMP-TABLE ttCust NO-UNDO BEFORE-TABLE ttCustBef FIELD CustNum AS INTEGER FIELD Name AS CHARACTER INDEX CustNumIdx IS UNIQUE PRIMARY CustNum. DEFINE TEMP-TABLE ttOrder NO-UNDO BEFORE-TABLE ttOrderBef FIELD OrderNum AS INTEGER FIELD CustNum AS INTEGER INDEX OrderNumIdx IS UNIQUE PRIMARY OrderNum INDEX CustOrdIdx IS UNIQUE CustNum OrderNum. DEFINE DATASET dsCustOrd FOR ttCust, ttOrder DATA-RELATION CustOrdRel FOR ttCust, ttOrder RELATION-FIELDS (CustNum, CustNum). DEFINE INPUT PARAMETER iCustNum AS INTEGER. DEFINE OUTPUT PARAMETER DATASET FOR dsCustOrd. /* fill dataset and return to caller */ ... |
<!-- datasetChanges document --> <complexType name="dsCustOrdChanges" prodata:datasetName="dsCustOrd" prodata:isDsChanges="true" prodata:namespace="WebServiceNameSpace:ObjectName"> <sequence> <any /> </sequence> </complexType> <!-- dataset definition --> <element name="dsCustOrd" prodata:proDataSet="true"> <complexType> <sequence> <element maxOccurs="unbounded" minOccurs="0" name="ttCust" prodata:beforeTable="BIttCust"> <complexType> <sequence> <element name="CustNum" nillable="true" type="xsd:int"/> <element name="Name" nillable="true" type="xsd:string"/> </sequence> </complexType> </element> <element maxOccurs="unbounded" minOccurs="0" name="ttOrder" prodata:beforeTable="BIttOrder"> <complexType> <sequence> <element name="OrderNum" nillable="true" type="xsd:int"/> <element name="CustNum" nillable="true" type="xsd:int"/> </sequence> </complexType> </element> </sequence> </complexType> </element> |