Re: Bill of materials explosion report

[Ray Ontko <rayo@ONTKO.COM>]

Yoav,

> Does anybody have any experience with creating a "bill of
> materials explosion report"  with SQR ?

If you're using Oracle, you may want to use the START WITH
and CONNECT BY clauses that Oracle's SQL offers, and use the
LEVEL psuedo-column to tell at what nesting level you are in
the query.

One approach that I don't think will work in SQR is to have
a procedure that you call recursively to print the sub-parts
for a given part.  SQR doesn't easily support recursive
procedures, and I think the calling procedure will lose its
query context when it calls itself and starts another query.

Does this make sense?  Hope this helps.

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/