DIM and Associated Fields (GRX)

GCC Consulting gccconsulting at comcast.net
Wed Dec 17 07:02:10 PST 2008


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.celestial.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.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
> _______________________________________________
> 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