Norman Biggar
Member
What I'm looking for is a procedure that can take the handle of a ProDataSet and produce a Query Clause that would walk through the ProDataSet.
For example
Would return
Has anyone done this or something similar?
I'm guessing the NUM-BUFFERS attribute of the PDS and the WHERE-STRING of the data-relations will come into it somewhere?
For example
Code:
DEFINE DATASET dsSports2000
FOR ttCustomer, ttOrder, ttOrderLine
DATA-RELATION dr1 FOR ttCustomer, ttOrder NESTED
RELATION-FIELD(CustNum,CustNum)
DATA-RELATION dr2 FOR ttOrder, ttOrderLine NESTED
RELATION-FIELD(OrderNum,OrderNum).
Code:
FOR EACH ttCustomer,
EACH ttOrder WHERE ttOrder.CustNum = ttCustomer.CustNum,
EACH ttOrderLine WHERE ttOrderLine.OrderNum = ttOrder.OrderNum
Has anyone done this or something similar?
I'm guessing the NUM-BUFFERS attribute of the PDS and the WHERE-STRING of the data-relations will come into it somewhere?