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