DIM problem

Jean-Pierre A. Radley appl at jpr.com
Fri Feb 24 09:49:10 PST 2012


Scott Walker propounded (on Thu, Feb 23, 2012 at 08:16:51PM -0500):
| 
| 
| > -----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?

Not according to the filePro Help example, and anyhow I tried adding the
parenthesis, didn't help.

-- 
JP


More information about the Filepro-list mailing list