DIM problem
Scott Walker
ScottWalker at RAMSystemsCorp.com
Thu Feb 23 17:16:51 PST 2012
> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
> Jean-Pierre A. Radley
> Sent: Thursday, February 23, 2012 7:52 PM
> To: filePro Mailing List
> Subject: DIM problem
>
> FilePro 5.6.10D4.
>
> Here is part of a map:
>
> 31 - Q0) 1999 quantity sold: 7:.0:
> 32 - Q0) 2000 quantity sold: 7:.0:
> ....
> 44 - Q0) 2012 quantity sold: 7:.0:
> 45 - Q0) 2013 quantity sold: 7:.0:
>
> Here's the start of a processing table:
>
> If: 'Associated Fields Q0 are for QuantitySold 1999 to 2013
> Then: dim QSold(15):Q0
>
> When running the processing, the first record encountered wants to use
> this array with a value of "12". But this error occurs:
>
> *** A filePro Error Has Occurred ***
> Array Index Out of Range: dim Qgroup(-16512) -- Index: 12
> Output Processing
> Line Number: 7
>
> Qgroup(i) = Qgroup(i) + mon(A5))
>
> Process contains a syntax error at position indicated.
>
> (I see no position indicated...)
>
> I have no problem if I change that snippet of the processing table to:
>
> If: 'fields 31 to 45 are for QuantitySold 1999 to 2013
> Then: dim QSold(15):31
>
> Why does mapping the array to the associated field name fail?
>
> BTW: t'would be a major help if fP error messages ALSO showed the
> file name and table name.
>
> --
> JP
JP,
Just a wild untested guess.....everywhere you reference an associated field
in processing don't you need to use the ")" as in Q0) . Maybe you need
that in the dim statement?
Regards,
Scott
More information about the Filepro-list
mailing list