HI I have been unable to duplicate this query.
It uses 5 files it matches from the orderhistory file to customer, and
shipping, invoice history and address files.
OHENT# EQ ADENT#
OHSFX# EQ ADSFX#
OHORD# EQ IDORD#
OHENT# EQ ACENT#
OHSFX# EQ ACSSF#
has some record selects and sorting, no problems so far. Does totals on qty
shipped and $shipped.
Does break levels on 9 fields. this is the part I cannot translate. then
puts the data to a temp file.
I am not getting the same number of records no matter what. am sure the
issue is how to code this Break in SQL.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact