A
ashon shakya
Guest
@openapi.openedge.entity.primarykey (fields="CustNum"). DEFINE TEMP-TABLE ttCustomer BEFORE-TABLE bttCustomer FIELD id AS CHARACTER FIELD seq AS INTEGER INITIAL ? FIELD CustNum AS INTEGER INITIAL "0" LABEL "Cust Num" FIELD Country AS CHARACTER INITIAL "USA" LABEL "Country" ....... @openapi.openedge.entity.primarykey (fields="Ordernum"). DEFINE TEMP-TABLE ttOrder BEFORE-TABLE bttOrder FIELD Ordernum AS INTEGER INITIAL "0" LABEL "Order Num" FIELD CustNum AS INTEGER INITIAL "0" LABEL "Cust Num" FIELD OrderDate AS DATE INITIAL "TODAY" LABEL "Ordered" ......... DEFINE DATASET dsCustomerOrder FOR ttCustomer,ttOrder DATA-RELATION drCO for ttCustomer,ttOrder RELATION-FIELDS (CustNum, CustNum) . I used the above schema to create a business entity but the datasource-table are not automatically filled. Also how to create count function for this buisness entity.
Continue reading...
Continue reading...