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