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