DIM and Associated Fields (GRX)
GCC Consulting
gccconsulting at comcast.net
Tue Dec 16 19:36:33 PST 2008
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)IndCartType1Count 35- a2)IndCartType6Count
> > > 6- last activity 21-
> > > a2)IndCartType2Count 36- a2)IndCartType7Count
> > > 7- date 22-
> > > a2)IndCartType3Count 37- a2)IndCartType8Count
> > > 8- time 23-
> > > a2)IndCartType4Count 38- a2)IndCartType9Count
> > > 9- user 24- a1)IndCartType5
> > > 39- a2)IndCartType10Count
> > > 10- wholesaler name 25- 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 processed 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