Hi,
Is it possible to fill a dataset from one table in a multiple table query.
eg. A query finds OrderLines for a particular Customers and Orders ie. For Each Customer, Each Order, Each OrderLine...............etc.
I want the dataset to only contain the resulting OrderLine records found. Is it possible to set up a Dataset/Datasource/Query to automatically do this through the DATASET-HANDLE:FILL() method or do I have to create the TEMP-TABLE records myself and point the dataset to them ?
I've gone through the v10a manual (6 white papers on datasets) but couldn't find any example of this.
Regards,
David Morrison
Shuttleworth Business Systems
Is it possible to fill a dataset from one table in a multiple table query.
eg. A query finds OrderLines for a particular Customers and Orders ie. For Each Customer, Each Order, Each OrderLine...............etc.
I want the dataset to only contain the resulting OrderLine records found. Is it possible to set up a Dataset/Datasource/Query to automatically do this through the DATASET-HANDLE:FILL() method or do I have to create the TEMP-TABLE records myself and point the dataset to them ?
I've gone through the v10a manual (6 white papers on datasets) but couldn't find any example of this.
Regards,
David Morrison
Shuttleworth Business Systems