DIM and Associated Fields (GRX)
Chris Sellitto
sellich at guaranteedreturns.com
Wed Dec 17 06:21:53 PST 2008
Thanks for the replies. I guess I should have been a little more specific.
I have version 5.0.14RN9. My question is, can you build an array on non-contiguous
associated fields using the version I have.
Thanks
Chris
> John,
> That is true in 5.6. I don't think one cam build an array across non-contiguous associated fields in older versions.
> If I recall correctly, I asked about this as I was building an fp
> spreadsheet type application for a client and after about 6 months he asked me to expand the elements. This required me to add 5 more sets of associated fields which used different arrays.
> Fptech was advised on this and fixed this in a later version. Maybe 5.0.14 but this should work in 5.6.
> Not sure of the lookup piece though.
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
> -----Original Message-----
> From:
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
>
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On
> Behalf Of John Esak
> Sent: Tuesday, December 16, 2008 5:11 PM
> To: 'Chris Sellitto'; filepro-list at lists.celestial.com
> Subject: RE: DIM and Associated Fields (GRX)
>
> Incidentally, I mentioned that the dimension and the associated field
group
> have to match up in number of elements.... But the associated field
> group does not have to be contiguous... Id don't mean that. In your
> case, you would just build an 8 element array starting at a1) and
> filepro will
figure
> the thing out for you no matter where it finds the a1) elements.
>
> John
>
>
> > -----Original Message-----
> > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of John Esak
> > Sent: Tuesday, December 16, 2008 5:06 PM
> > To: 'Chris Sellitto'; filepro-list at lists.celestial.com
> > Cc: 'filePro'
> > Subject: RE: DIM and Associated Fields (GRX)
> >
> > I think your problem might be that there are only 8 fields in the
> > a1) associated field group. (the others are a2)).... So, the array
> > you've overlaid on them is stepping you out of bounds.
> >
> > I haven't looked closely at your code... Just read what you wrote
> > and that sounded wrong.
> >
> > But, on the whole, yes, you can build an array over an associated
> > field group... And I suppose over an associated field group in a
> > lookup file as well. (never did this, but don't see why it wouldn't
> > work if the fields and elements match up in number).
> >
> > John Esak
> >
> >
> > > -----Original Message-----
> > > From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > > [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> > m] On Behalf Of Chris Sellitto
> > > Sent: Tuesday, December 16, 2008 4:07 PM
> > > To: filepro-list at lists.celestial.com
> > > Subject: DIM and Associated Fields (GRX)
> > >
> > > I am dealing with a file that somebody else created. The layout
> > > is as follows.
> > >
> > > D E F I N E P R O C E S S I N G
> > > 5.0.14RN9
> > > --------------------------------------------------------------
> > > 1- skid 16- a1)IndCartType1 31- a1)IndCartType12
> > > 2- wholesaler # 17- a1)IndCartType2 32- a1)IndCartType13
> > > 3- curr location 18- a1)IndCartType3 33- a1)IndCartType14
> > > 4- prev location 19- a1)IndCartType4 34- a2)IndCartType5Count
> > > 5- status 20- a2)IndCartType1Count35- a2)IndCartType6Count
> > > 6- last activity 21- a2)IndCartType2Count36- a2)IndCartType7Count
> > > 7- date 22- a2)IndCartType3Count37- a2)IndCartType8Count
> > > 8- time 23- a2)IndCartType4Count38- a2)IndCartType9Count
> > > 9- user 24- a1)IndCartType5 39- a2)IndCartType10Count
> > > 10- wholesaler name25- a1)IndCartType6 40- a2)IndCartType11Count
> > > 11- front/rear 26- a1)IndCartType7 41- a2)IndCartType12Count
> > > 12- division 27- a1)IndCartType8 42- a2)IndCartType13Count
> > > 13- # boxes 28- a1)IndCartType9 43- a2)IndCartType14Count
> > > 14- #boxes process 29- a1)IndCartType10
> > > 15- mailer number 30- a1)IndCartType11
> > >
> > > My Question is:
> > >
> > > Can I build a 14 element array on a1). For instance, is the
> > > following a valid statement?
> > >
> > > DIM IndCartType(14)(8,LJ):skid(a1))
> > >
> > > Knowing that a valid lookup to the file using "skid" as an alias
> > > was performed.
> > >
> > > When I run a syntax check it does not give me an error.
> > >
> > > When I run the process I receive the following.....
> > >
> > >
> > > *** A filePro Error Has Occurred ***
> > >
> > > On File: /filepro/gr_skids/index.A
> > >
> > > Output Processing
> > > Line Number: 194
> > > (IndCartType(x) co Indate_BoxSkid2) and (IndLoopOccur eq "1")
> > > IndCartTypeCount(x)=IndCartTypeCount(x)+"1";FoundIndBox="Y";go
> > > to LupDun3
> > >
> > >
> > > Reference to a field that doesn't exist.
> > >
> > >
> > > Press H -Hardcopy ?--+ -Continue
> > >
> > >
> > > I am assuming it means that IndCartType(x) is generating this error.
> > >
> > > - X is defined as (2,.0)
> > >
> > > Any suggestions/solutions would be greatly appreciated.
> > >
> > > Thank you
> > >
> > > Christopher Sellitto
> > > VP Computer Operations
> > > Guaranteed Returns
> > > 100 Colin Drive
> > > Holbrook, NY 11741
> > > (631) 689-0191 x132
> > > mailto:sellich at guaranteedreturns.com
> > > _______________________________________________
> > > Filepro-list mailing list
> > > Filepro-list at lists.celestial.com
> > > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > >
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list