Topic: Mapping Arrays To Fields
Greetings,
Is it possible to map an array to a set of fields?
I have to record a set of statuses (they are numeric) for a set of operations, each operation will have its own row in the DB.
I then have to keep a running MIN, MAX, AVG for the last 25 tests. When a new test is run I need to shift the values and compute
a new set of MIN, MAX, AVG for the then last 25 tests.
Now I can shift filed25 := field24, etc down the list to shift and I can check MIN, MAX and sum up for AVG in a long set of
statements or if I can map an array I can do all in a fairly compact loop structure. If I move field values to an array then I have to
move them back, there probable not much to be gained... just wondering if it is possible to not have to write a novel of code?
Regards,
Keith