Re: Product Structure SQL

Greg,

I have a similar need and would appreciate if I could have permission to
contact you for your sample RPG program?

Jim Martinson
IT Manager
Timesavers Inc
jmartinson@timesaversinc.com


----- Original Message -----
From: "Greg Wenzloff" <GWenzloff@beckmfg.com>
To: "'MAPICS ERP System Discussion'" <mapics-l@midrange.com>
Sent: Thursday, January 23, 2003 1:57 PM
Subject: RE: Product Structure SQL


> Tom... The way the Product Structure file (PSTRUC) is organized, I do not
> think it is possible with SQL/Query/Access/Excel.   You would need a
program
> to chase from Parent to Component (PINBR to CINBR).    This gets tricky
when
> there are assortments or kits.    If you would like a sample RPG program
> contact me offline.
>
> IMO,
> Greg
>
> -----Original Message-----
> From: Tom Wood [mailto:TomW@fortrecoveryindustries.com]
> Sent: Thursday, January 23, 2003 2:41 PM
> To: mapics-l@midrange.com
> Cc: Shawn Thobe
> Subject: Product Structure SQL
>
>
> Hello All,
>
>
>
> Anyone have a  pc app (excel or access) that uses ODBC, etc. and has  a
> SQL query that successfully will produce an indented bill of material?
> We're working on a little project where we want to throw the BOM into
> Access or Excel and can't seem to put together the proper joins to
> accomplish this.  Probably something simple. Any hints, examples, etc.
> appreciated.
>
>
>
> Thanks,
>
>
>
> Tom Wood
>
> Fort Recovery Industries Inc.
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>