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