DIM and Associated Fields (GRX)
Chris Sellitto
sellich at guaranteedreturns.com
Wed Dec 17 08:07:53 PST 2008
Richard,
The version looks like my problem. Your code snippet is a good
alternative. I
will give it a try.
Thank you
Chris
> -----Original Message-----
> From: GCC Consulting [mailto:gccconsulting at comcast.net]
> Sent: Wednesday, December 17, 2008 10:02 AM
> To: Chris Sellitto; filepro-list at lists.celestial.com
> Subject: RE: DIM and Associated Fields (GRX)
>
> Chris,
>
> I tested this with 1.0.14 odbc version of fp equivalent to
> 5.0.14 and dim
> foobar:a1) gave a syntax error.
>
> Tested in 5.6.06 the same non-contiguous associated fields
> dimfoobar:a1) passed the syntax check and worked.
>
> Map: file test
> 1. A1) test 1 *
> 2. A1) test 1 *
> 3. space 2 *
> 4. A1) test 1*
> 5. a1) test 1 *
>
> Associated fields set to a,b,c,d
>
> Space set to zz
>
> Process:
>
> Dim foobar(4):a1)
> Sl=listbox(foobar)
>
> Result:
> A
> B
> C
> D
>
> Since I don't have 5,0.14 you could try this test to see if
> it will work.
> If it doesn't, it may work in 5.0.15. I would suggest that
> you ask anyone running 5.0.15 test this out before upgrading
> to this version. 5.0.15 has fptechs license manager working.
>
> So, unless this is an imperative, set up multiple arrays for
> each group of associated fields and then one large array to
> hold the values from each smaller array. This would then
> allow you to manipulate the larger arrays rather then a bunch
> of smaller arrays.
>
> Dim cart_type_1(4):16
> Dim cart_type_2(4):24
> Dim cart_type_1(4):30
> Dim all_carts(12)
>
> If: ct=""
> Then: ct="1";dc="1"
> If: ct le "4"
> Then: all_carts[dc]=cart_type_1[ct];ct=ct+"1";dc=dc+"1"
> If: ct ge "4"
> Then:ct="1"
> If: ct le "4"
> Then: all_carts[dc]=cart_type_2[ct];ct=ct+"1";dc=dc+"1"
>
> The above is quick. Do this for each set of associated
> fields and you will end up with 2 12 element arrays to work with.
>
> Richard
>
>
>
>
> > -----Original Message-----
> > From:
> > filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
> >
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com]
> On
> > Behalf Of Chris Sellitto
> > Sent: Wednesday, December 17, 2008 9:22 AM
> > To: filepro-list at lists.celestial.com
> > Subject: RE: DIM and Associated Fields (GRX)
> >
> > 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.c
> elestial.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
> > _______________________________________________
> > 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