O
oedev
Guest
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().
Continue reading...
Continue reading...