O
ornhill
Guest
Adresser:http//shtmlnikia.dk fra min HTC-telefon ----- Reply message ----- Fra: "oedev" bounce-oedev@community.progress.com Til: TU.OE.Development@community.progress.com Emne: [Technical Users - OE Development] Prodataset issue Dato: man., feb. 23, 2015 16:51 Prodataset issue Thread created by oedev Taking the following example code, I can an error when running "Must assign a user query to a data-source that is a join before filling" (11980) I've tried changing the data source srcOrderLine to a query as well (on the tables ORDER_LINE and PRODUCT), but I then get all the orderline records in the database. Must be doing something obvious and simple wrong?! DEFINE TEMP-TABLE ttOrder LIKE order. DEFINE TEMP-TABLE ttOrderLine LIKE orderline FIELD ProductRef AS CHAR FIELD ProductDescription AS CHAR. DEFINE DATASET dsOrder FOR ttOrder, ttOrderLine DATA-RELATION OrderOrderLine FOR ttOrder, ttOrderLine RELATION-FIELDS (ttOrder.order_number, ttOrderLine.order_number). DEFINE QUERY qOrder FOR CUSTOMER, ORDER. DEFINE DATA-SOURCE srcOrder FOR QUERY qOrder. DEFINE DATA-SOURCE srcOrderLine FOR ORDERLINE KEYS (ORDER_NUMBER), PRODUCT KEYS (PRODUCT_NUMBER). QUERY qOrder:QUERY-PREPARE("FOR EACH CUSTOMER WHERE CUSTOMER_REFERENCE = '1111111' NO-LOCK, " + "LAST ORDER OF CUSTOMER NO-LOCK"). BUFFER ttOrder:ATTACH-DATA-SOURCE(DATA-SOURCE srcOrder:HANDLE). BUFFER ttOrderLine:ATTACH-DATA-SOURCE(DATA-SOURCE srcOrderLine:HANDLE). DATASET dsOrder:FILL(). Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...